Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or no VBA, that is the question
Hi All......
Can someone please tell me if it's possible to write a macro that will scan all the .xls files in a given directory and create a list identifying whether of not there is any VBA code in each file, by name? TIA Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or no VBA, that is the question
no creo... unless you open each file... other than that yo creo que no.
Que dios te lo pague y que san pedro te lo clave. :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or no VBA, that is the question
Thank you, but I do understand that each file will have to be opened,
interrogated, and closed............this is acceptable under VBA control. Vaya con Dios, Chuck, CABGx3 "Cesar Zapata" wrote in message ups.com... no creo... unless you open each file... other than that yo creo que no. Que dios te lo pague y que san pedro te lo clave. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
UDF Question | Excel Programming |