Paul,
Unless you read through the Excel file format and understand where such VBA
records are, you are stuck with the suggestions in that thread.
Anyone else can come up with a different approach....

NickHK

"Paul Martin" wrote in message
oups.com...
Thanks for pointing me to that post, Nick. I'm not sure if it helps
me, because I'm trying to find a relatively easy solution. Rather than
scanning all the modules, I was thinking there must be a byte or
something that Excel reads when opening a file to test whether macros
exist. Is there an API or something that can enable me to do such a
test?

Regards

Paul


NickHK wrote:

Paul,
See the recent thread in this NG "Need to scan xls files and identify if
they use macros...wanna use VB".

NickHK

"Paul Martin" wrote in message
oups.com...
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