VBA File Search

June 28, 2010 at 07:11:02
Specs: Windows XP, n/a
Dear All

I need to search a huge server full of disorganised files to find which have VBA modules in them. This is restricted to Excel files only.

Is it possible to identify files which have code modules in them without having to do a manual search? Any thoughts greatly appreciated. Thanks.


See More: VBA File Search

Report •

June 28, 2010 at 15:44:00
this not guaranteed to work, but my preliminary tests looked consistant:
@echo off & (
for /f "tokens=*" %%a in ('dir /b /s /a-d *.xls') do find /i /c "vbaproject" >nul && echo %%a
) > vba_xls.log
::---- end
sorry this was the best i can do hack-job. Someone with more knowledge about excel file header fields could probably help. I'm sure there's a correct way but i don'know it.

Report •
Related Solutions

Ask Question