I would like to list all Excel Files containing Macros in a Folder and Subfolders.
Is it possible to do it with Windows Search or Agent Ransack or Filesearch Pro?
There are a limited number of Macro-Enabled
workbook types, which are
.XLSM
(workbook).XLTM
(template file).XLSB
(binary file, nod to PeterH)Searching your drive (using the tool of your choice) for these file extensions will list all Excel files which are usually used for macros.
If you attempt to save an Excel workbook that contains macros, but choose a format which doesn't support macros, you'll receive the following prompt
.xlsb
is a new one on me.
Jun 21, 2021 at 8:57
.xlsm
extension. Search for it..xls
doesn't support macros.*.xls
files have always supported macros.