ExcelBanter - Searching VBA Code

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Searching VBA Code (https://www.excelbanter.com/excel-programming/395156-searching-vba-code.html)

kbannon

Searching VBA Code

I would like to develop a system that will allow me to scan files
(word/excel/access/PPT) for linked tables, documents & OLE links, etc.
To be able to search the VBA code (sheet code and modules) of these
(using Excel as an example), how would you search the (unprotected)
VBA code of each file for certain link strings?

kbannon

Searching VBA Code

found this - http://www.dicks-blog.com/archives/2...a-code-string/

All times are GMT +1. The time now is 05:16 PM.