0

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?

6
  • 1
    Macro-enabled excel files have .xlsm extension. Search for it. Jun 21, 2021 at 8:20
  • 1
    @ReddyLutonadio binary files can also have macros saved (.xlsb)
    – PeterH
    Jun 21, 2021 at 8:57
  • Search *.xlsm, *.xls directly。
    – Lee
    Jun 21, 2021 at 9:04
  • @Lee .xls doesn't support macros. Jun 21, 2021 at 9:32
  • 2
    @spikey_richie *.xls files have always supported macros. Jun 21, 2021 at 11:20

1 Answer 1

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

enter image description here

8
  • you can still save a file as .XLSM without actually having any macros in there
    – PeterH
    Jun 21, 2021 at 8:55
  • and binary files can contain macros (.xlsb)
    – PeterH
    Jun 21, 2021 at 8:56
  • "you can still save a file as .XLSM without actually having any macros in there" _ I thought that was pretty obvious, so I didn't mention it explicitly. .xlsb is a new one on me. Jun 21, 2021 at 8:57
  • It is obvious, but not what OP asked for, and yh i always use binary files as default as they are often smaller in size than .xlsm
    – PeterH
    Jun 21, 2021 at 9:00
  • 1
    Since the OP accepted your answer, there's not much point. As is common, it may be that what he really wanted is not what he asked for. In any event, I don't believe that his stated requirements can be satisfied in Windows Search, and I'm not familiar with Ransack. Jun 22, 2021 at 11:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .