| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a macro to fix another macro
I just noticed there is a problem with one macro I wrote that has been
put into more than 70 similar but different files. Instead of going into each file to edit the macro, is there a way to create a macro and go into each file to fix that problemlic macro? I can loop through a list to repeat same actions for these 70 or so files, but couldn't figure out a way to use macro to change another macro. Help please. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to write a macro to fix another macro
Try taking a look here ...
http://www.cpearson.com/excel/vbe.htm HTH. "whatever" wrote: I just noticed there is a problem with one macro I wrote that has been put into more than 70 similar but different files. Instead of going into each file to edit the macro, is there a way to create a macro and go into each file to fix that problemlic macro? I can loop through a list to repeat same actions for these 70 or so files, but couldn't figure out a way to use macro to change another macro. Help please. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| write a macro to run a macro | Excel Discussion (Misc queries) | |||
| How to write a macro to do... | Excel Programming | |||
| Can one VB macro write another macro? | Excel Worksheet Functions | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Need help to write macro please | Excel Programming | |||
![whatever[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
