Chris Waller
Board Regular
- Joined
- Jan 18, 2009
- Messages
- 183
- Office Version
- 365
- Platform
- Windows
Hi All,
I am hoping that someone can help me. I am trying to identify 4 phrases in the VBA of a large number of workbooks. I am currently doing this manually, but I'd rather automate it just because it's more accurate and quicker than I can do it manually. I am looking for the following Application.Workbooks.Add or Application.Workbooks.Open or Scripting.filesystemobject or ThisDocument.Path. If someone could give me an idea of how I could create some VBA that could check the VBA of a workbook that I open that would be great. I have to make a note of all the files I have checked and the results, so any help would be greatly appreciated.
I am hoping that someone can help me. I am trying to identify 4 phrases in the VBA of a large number of workbooks. I am currently doing this manually, but I'd rather automate it just because it's more accurate and quicker than I can do it manually. I am looking for the following Application.Workbooks.Add or Application.Workbooks.Open or Scripting.filesystemobject or ThisDocument.Path. If someone could give me an idea of how I could create some VBA that could check the VBA of a workbook that I open that would be great. I have to make a note of all the files I have checked and the results, so any help would be greatly appreciated.