| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check to see if a Workbook has a Macro
I've got a list of approximately 12000 Workbooks. I want to be able to find
out which contain macros. Apart from opening each one manually is there a way i can open the Workbook and programatically check to see if a macro exists. I'm not concerned about number of procedures forms, Modules etc, just to see if it contains even a recorded macro. Thanks for any suggestions on this. Regards, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro, how can I check if an opened workbook was changed ? | Excel Programming | |||
| Macro in Excel to check if another workbook is opened. | Excel Programming | |||
| Before macro runs - check workbook name | Excel Programming | |||
| How to check workbook is already opened before passing the workbook obj to a subroutine in Word | Excel Programming | |||
| Check if workbook has been changed | Excel Programming | |||
Threaded Mode
