Is there a way to list all excel files containing Macros in a Folder and Subfolders?
Solution 1:
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
