ExcelBanter - View Single Post - Updating the code in multiple workbooks

Thread: Updating the code in multiple workbooks

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Phil Hibbs Phil Hibbs is offline

Phil Hibbs is offline

external usenet poster

Posts: 100

Default

Updating the code in multiple workbooks

I have investigated the Excel4MacroSheets property and the Modules
property of the Application but these appear to be empty lists. I was
hoping one or other would contain a list of the macro modules and the
text of the macro code so I could update that.

Phil Hibbs.

Reply With Quote

Reply With Quote