ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VBA to search all macro code in Excel module for specific string criteria (https://www.excelbanter.com/excel-programming/298839-excel-vba-search-all-macro-code-excel-module-specific-string-criteria.html)

Roger1947

Excel VBA to search all macro code in Excel module for specific string criteria
 
Hi all,

I am looking to write a Excel XP vba code which will allow me t
search for a specific search string in a Excel XP macro module for al
the "xls" spreadsheet type files in the folder location which wil
prompt me which could be "C:\" .

For example..I want to search all the spreadsheets for the strin
"C:\temp" hardcoded into the Excel XP macro module using an automate
solution like Excel XP VBA.

I am using Excel XP on Windows XP o/s.

Please help me out with the code as I have to present a report to m
manager in 2 days.

Thanks,
Roger.
E-mail:

--
Message posted from
http://www.ExcelForum.com



All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com