Search results for query: *

Sorry, I really should try harder before I post in here. The error message was associated with the IF statement not the line that changed the codename. Because I am going to be using data from a pivot table for the codename, the code supplied in the FAQ can be modified to work exactly as I...

Hi Geoff, I have tried to use the code from the FAQ but if I use an aplha-numeric entry it brings up an error on the line: [code]If NewRef = vbCancel Or NewRef = "" Then [\code] The error is "Run-Time Error 13: Type Mismatch". If I use a numeric entry it says the entry...

Hi all, Does anyone know if it is possible to change a worksheet's codename through VBA in Excel 97 (to prevent copied sheets being named Sheet12, Sheet 121, Sheet 1211, Sheet 12111 etc.)? I am using the Pivot Tables Show Pages option to create new sheets with each specific page item on a new...

Hi Paul, We always get this message if the number of rows is over 15,000 (using Office 97). We use three workarounds depending on the situation. 1. Export the data as XLS file, open file in Excel. 2. From Excel use the get external data option, or create a pivot table using the external...

Rob, Thanks, that is useful to me. Regards, Alan

Dale, I have to hand it to you, normally you astonish me with your knowledge of DB functions within Excel, but this time it is your methodology that has been invaluable to me. I tried the suggestion above and it worked fine (there was a company logo as a picture on the sheet which acts as a...

Hi all, I have a table in Excel which prints on multiple sheets of paper. Does anyone have any info they could share on how to put a total for a certain column (for example "G") in the footer for each page to show the total for that particular piece of paper? Regards, Alan

Thanks guys, Tranpkp, That works fine, and I will use it as soon as I can get the subject and message to appear. Chopsaki, sorry I couldn't find any reference to either newmail or cdonts in the help files. Regards, Alan

Hi all, I am using the following code to send a workbook through email (Eudora). What I would like to do is send an email message without the workbook if there is no data in the workbook. Does anyone have any ideas? [code]ActiveWorkbook.SendMail...

Ben, I couldn't manage to get your formatting to work, was this because there is nothing actually in the cells themselves (can you tell I couldn't follow it)? TopJack, Thanks for that, that worked fine, a star from me. Regards, Alan

Hi All, I have been given a spreadsheet which lists month names across the top in row 2, and days (1 - 31) down the side in Column 2 (the year name is in the worksheet tab). For example Sheet 2002!D4 is equivalent to 2nd February 2002. I have been "asked" to change the colour of the...

Thanks Geoff, I have just tried that - I assigned a different key to the copied macro and it works fine. Thanks for your time. Regards, Alan

Thanks Geoff, Wow that was fast, I was still looking at the other questions on the page by the time you replied. I only have a few macros run from shortcut keys (normally the ones run from external applications) and none of the others use the "e" key, and none of the open books have...

Hi all, All my Excel subs are stored in the hidden personal.xls. I recently changed the names of the modules to reflect the subs they contain. I have now found that one of the keyboard shortcuts (Ctrl + e) for a macro does not work, while the rest do. Looking at the Macro/Options dialogue...

Hi all, I am new to NT. Is there any way of finding out when the recycle bin was last emptied and who did it? Regards, Alan

I finally got that last bit sorted out. For any interested parties it seems the database was closing before it got a chance to run the macro. I am awarding BKClaw a star as his reply helped me a lot. Regards, Alan

Sorry - forget that last reply, it just meant that I didn't have Access open. Now I have Access open it comes up with a run time error 2501 saying something about how I used the runmacro command and then clicked cancel in a dialogue box. Now I know it is Friday afternoon, but I am pretty sure...

Thanks BKClaw, When I add your code and run the macro I get [code]Run Time Error 91 Object variable or With block variable not set[\code] at the acApp.OpenCurrentDatabase (NewDBM) line. Do you have any idea why this could be? Regards, Alan

Hi all, I have the following code (for which I apologise most sincerely) in an Excel spreadsheet that compacts an Access database to a separate location and then opens it. Is it possible to then run a macro stored in the database from the code in Excel? [code]Dim StandardDBM As Database Dim...

Hi, In Excel 97 I use rowgrand and columngrand to select the subtotals and turn them on or off eg. With ActiveSheet.PivotTables("PivotTable1") .ColumnGrand = False .RowGrand = False End With I don't know if that is sueful to you or not. Regards, Alan