Search for userform or procedure name?

  • Thread starter Thread starter salgud
  • Start date Start date
S

salgud

Tried to search XL files in Windoze Explorer for userform, procedure and
module names - doesn't work. Does anyone know of a search tool that can do
this? Sure would be handy!
Thanks in advance.
 
Tried to search XL files in Windoze Explorer for userform, procedure and
module names - doesn't work. Does anyone know of a search tool that can do
this? Sure would be handy!
Thanks in advance.
Click to expand...

Hi Salgud,

About 6 years ago I created a tool in Visual Basic 6 which could
scanned a complete folder.
It listed each Word and Excel file and reported if the file contained
VBA code.
It dit not look inside the VBA code.

To get what you want I guess you will need such a tool, but the tool
shoul open the file ina hidden instance of Word / Excel and open the
VBE.
Next it shoul loop thru all components to look for the names of the
forms, modules and possible classes.
If the code is protected you will not be able to collect this
infromation.

I know it is possible, but it might be to complicated to list here.

Sorry if you are disapointed by this aswer.

Regards,

Wouter.
 
Hi Salgud,

About 6 years ago I created a tool in Visual Basic 6 which could
scanned a complete folder.
It listed each Word and Excel file and reported if the file contained
VBA code.
It dit not look inside the VBA code.

To get what you want I guess you will need such a tool, but the tool
shoul open the file ina hidden instance of Word / Excel and open the
VBE.
Next it shoul loop thru all components to look for the names of the
forms, modules and possible classes.
If the code is protected you will not be able to collect this
infromation.

I know it is possible, but it might be to complicated to list here.

Sorry if you are disapointed by this aswer.

Regards,

Wouter.
Click to expand...

Thanks for the reply. I guess what I'm looking for doesn't exist at this
time.
 
Back
Top