| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Need to scan xls files and identify if they use macros...wanna use VB
I was on a project to do something similar, and besides an automated
chaeck, there was a need to have each Excel file with potential code/upgrade issues checked. I believe there is a HasMacro bit you can check on each file. Also, if that doesn't exist, you can count the lines of the modules, trim the empty space, then have a some criteria where the string needs to be greater than some small value to qualify as having code. James Igoe || http://code.comparative-advantage.com Jim Hicks wrote: I was given a project to scan all of the Excel files on our network and generate a report listing the files and wether they use Macros. I was thinking of using VB6 to scann all dirs/subdirs...easy part. Question: -- How do I quickly scan an excel file and determine if it has/uses Macros using VB6. I appreciate you taking the time to read this and any help anybody can provide. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I open files without doing a virus scan first? | Excel Discussion (Misc queries) | |||
| Need to scan xls files and identify if they use macros...wanna use | Excel Discussion (Misc queries) | |||
| Need to scan xls files and identify if they use macros...wanna use | Excel Programming | |||
| Need to scan xls files and identify if they use macros...wanna use | Excel Discussion (Misc queries) | |||
| Need to scan xls files and identify if they use macros...wanna use | Excel Programming | |||
Hybrid Mode
