Home > IT Answers > Development > find which excel spreadsheets contain macros
FreemaG
5 pts.
 find which excel spreadsheets contain macros
Excel macros, Macros, Microsoft Excel, VBScript
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?

Software/Hardware used:
ASKED: November 12, 2008  5:21 PM
UPDATED: November 17, 2008  7:06 PM
RELATED QUESTIONS
Answer Wiki:
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.....
Last Wiki Answer Submitted:  November 14, 2008  9:38 pm  by  SbElectric   2,510 pts.
All Answer Wiki Contributors:  SbElectric   2,510 pts. , Technochic   56,975 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Can you use the .xlsm extension even if the file does not contain macros? Does word have a similar extension notation system?

Flame
 14,895 pts.