How to determine if an .xls file contains VBA Code

[caisjef]

Hi,

I have several hundred spreadsheets to go through and detect wether it contains VBA code.

I have the complete path of each file in a cell, is there a way to detect if the file contains vba code, without opening each file individually?

Your help is greatly appreciated!

 

[Gettingbetter]

Hi Caisjef,

Welcome to the board.

Take a look at this page

http://j-walk.com/ss/excel/tips/tip70.htm

Is this what you are after?