Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA (Macro) to Update Existing Macro
Hi.
I have about 100 files that have the same embedded macro in them. I need to update one of the functions that is contained in the macro code. I know how to loop through all the files, open each one, and save/ close them. What I don't know how to do is modify the embedded macro functions. Can someone please tell me how I can replace a function with a new one automatically so I don't have to open the code editor for each one. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Use existing macro to create another macro | Excel Programming | |||
Recording a macro within existing macro. | Excel Programming | |||
Macro Help - check existing tabs | Excel Programming | |||
Change to existing macro | Excel Programming |