Is there way to find Office files on share which contain macros? RRS feed

  • Question

  • 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 them?

    Tuesday, March 17, 2015 5:32 PM