| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to programmatically test whether VBA code exists in an Excel file
Hi all
I am writing some code that loops through multiple Excel workbooks (may be open or not) and I am wondering if there's an Application or VBProject property that I can access that indicates that a given workbook has code in it. It seems logical that there is such a property, as a workbook with code prompts the user that macros are present. Is this property available through VBA? And if so, how? Thanks in advance Paul Martin Melbourne, Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test if file exists | Excel Discussion (Misc queries) | |||
| How can I programmatically check in Excel 2002 if a sheet exists? | Excel Programming | |||
| How to test if a DLL (library) exists | Excel Programming | |||
| How to test if an Excel spreadsheet exists in VBScript? | Excel Programming | |||
| Excel VBA - How do I programmatically change source code in another file? | Excel Programming | |||
Threaded Mode
