MrExcel Publishing
Your One Stop for Excel Tips & Solutions

how can I determine if an excel file contains macros or not?

Posted by JJ on May 07, 2001 11:14 AM

Can this be done by a Macro - to go thru all the excel files on my hard drive and find out all the files that have macros. Please help!

Posted by Kevin James on May 07, 2001 11:39 PM

Microsoft's product support page:

In the first box choose Excel97

In the second box type:
list all macros in all files

To answer your question, yes, it seems feasible that you could write a macro to open all files separately and then see if there is a macro attached.

Here are some other helpful links I've accumulated in the past few weeks: Advanced

Posted by J J on May 08, 2001 5:52 PM

I got it :) thanks!!