| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to replace vba code in one excel workbook from another workboo
Hi all,
Let say that I have over 2000 old excel files in one folder. Each of these excel files contain one macro and this is the same macro in all excel files. I want to be able to create a script that will open each file one by one, delete or overwrite the current macro by a new one. All my code to open excel files is done and working. My problem is that I don't know how to retrieve the current macro once the file is open. Neither how to overwrite it. Any help will be greatly appreciated. Christian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data from one workbook automatically entered into another workboo. | Excel Discussion (Misc queries) | |||
| transfer formulas/formats from 2007 workbook to a new 2008 workboo | Excel Worksheet Functions | |||
| How to find/replace all of the names of files in EXCEL workbook. | Excel Discussion (Misc queries) | |||
| Tranferring names defined in one excel workbook to another workboo | Excel Discussion (Misc queries) | |||
| Can you code a macro so it runs multiple times in the same workboo | Excel Discussion (Misc queries) | |||
Threaded Mode
