ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Search for Code (https://www.excelbanter.com/excel-programming/384978-search-code.html)

bw

Search for Code
 
Is it possible to search for specific VB code (a literal string), for
all Excel Programs that are stored on my computer?




NOPIK

Search for Code
 
On Mar 10, 5:30 pm, "bw" wrote:
Is it possible to search for specific VB code (a literal string), for
all Excel Programs that are stored on my computer?

Look in Help or manual:

Application.FileSearch

VBProject


bw

Search for Code
 
Maybe I'm dense, but Application.FileSearch seems to search for files,
not text within the files.
I want to look for specific VB code.

Thanks, Bernie


"NOPIK" wrote in message
oups.com...
On Mar 10, 5:30 pm, "bw" wrote:
Is it possible to search for specific VB code (a literal string), for
all Excel Programs that are stored on my computer?

Look in Help or manual:

Application.FileSearch

VBProject



Doug Glancy[_7_]

Search for Code
 
bw,

I remember this post on Daily Dose of Excel. I don't know if they came up
with a good answer, but it looks like some ideas.

http://www.dailydoseofexcel.com/arch...-vba-projects/

hth,

Doug

"bw" wrote in message
...
Is it possible to search for specific VB code (a literal string), for all
Excel Programs that are stored on my computer?






bw

Search for Code
 
Hi Doug,

There is a program "AgentRansack" in the link you provided, which is
recommended and professes to find vb code in Excel, but it doesn't work
to my satisfaction at all.

I find it strange that searching for code in a Excel and/or Access would
not be a routine thing for programmers.

Thanks for the link, and your help.
Bernie


"Doug Glancy" wrote in message
...
bw,

I remember this post on Daily Dose of Excel. I don't know if they
came up with a good answer, but it looks like some ideas.

http://www.dailydoseofexcel.com/arch...-vba-projects/

hth,

Doug

"bw" wrote in message
...
Is it possible to search for specific VB code (a literal string), for
all Excel Programs that are stored on my computer?








All times are GMT +1. The time now is 05:11 AM.

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