Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro to open excel file and replace VBA module with update
I do not know if this is possible but can only ask.
I've got a series of workbooks that have a module which contains UDF's in a module. I've since discovered that one of the UDF's wasn't calculating correctly and had to make a change, since then, I've now got to go over every workbook that I created with the old UDF and update it. Was hoping that there is a way to programatically open up each workbook and replace the existing VBA module with a new one to save time... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Module not file when open the excel file | Excel Discussion (Misc queries) | |||
Ghost Links which force Excel to update on File Open | Excel Programming | |||
Macro to replace a VBA module? | Excel Programming | |||
Replace Excel File Open with Windows Explorer | Excel Discussion (Misc queries) | |||
Automate open file, update links, run macro, close and save file | Excel Programming |