Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros Excel 2002 updating file names
I am working on budget files for our new fiscal year. I need to update all of
my macros from referencing budget 08-09 to referencing budget 09-10. The problem is, I have over 100 worksheets included within the macro to change to the new budget year, but I don't want to have to go into each macro and manually change 100 worksheet names. How can I update all the macros at the same time or can I? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros Excel 2002 updating file names
There is a replace function in the VBA editor. It is under the Edit menu bar.
It works just like the replace in Excel. You can replace "budget 08-09" with "budget 09-10". If you select the Current Project it will tkae care of all of the modules within the projct at once. -- If this helps, please remember to click yes. "cbaliles" wrote: I am working on budget files for our new fiscal year. I need to update all of my macros from referencing budget 08-09 to referencing budget 09-10. The problem is, I have over 100 worksheets included within the macro to change to the new budget year, but I don't want to have to go into each macro and manually change 100 worksheet names. How can I update all the macros at the same time or can I? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
Macros in Excel 2002 | Excel Worksheet Functions | |||
Updating links in Excel 2002 | Excel Discussion (Misc queries) | |||
Help for old macros with Excel 2002 | Excel Worksheet Functions | |||
Excel 2002 SP3: In Open Dialog, Some File Names Appear in Blue | Excel Discussion (Misc queries) |