Thanks in advance for reading this. if you think the question belongs in a different forum, please let me know. 

Our organization will be upgrading everyone from Office 2003 to Office 2013. We are aware of a few Excel 2003 files having incompatibility issues with Office 2013, specifically macros (vba code) are going through a conversion/evaluation process.

I wanted to do a search on our file shares for other files that we involved in the conversion may not be aware of which also have VBA code in them. Is there a way to search, either using Windows 8's File Explorer or Visual Basic, to locate all MS Office files having VBA code in

Hi Allan,

Since your question is related to Office Excel, our help might be limited.

If these files contain specific string or they have different extension, we might help you to get that goal.

To List all the specific extension files in a folder/partition and its subfolders

dir /s *.txt >listtxt.txt

We suggest you refer to TechNet Office forum for further support since they have more knowledge base and practice about this.

https://social.technet.microsoft.com/Forums/office/en-us/home?category=officeit

If you have further information about how to differentiate these excel files, welcome back and we will try find a way to realize it.

Regards

D. Wu