find which excel spreadsheets contain macros

5 pts.
Tags:
Macros
Microsoft Excel
Microsoft Excel macros
VBScript
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Microsoft made changes in Excel 2007. In Excel 2007, the file name must be .xlsm to contain macro. If it is .xlsx then it will not contain macro. This is true only on Excel 2007 – not on previous versions of Excel.

I do not know of any way to determine this without opening them, no.

Then if FreemaG is using Excel 2007, it would be fairly simple to display all spreadsheets in a folder using the ‘details’ view – which would identify the spreadsheets with macros though the file extension…..

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Flame
    Can you use the .xlsm extension even if the file does not contain macros? Does word have a similar extension notation system?
    14,925 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following