Looking for Excel VBA Example

[Jeff Arledge]

I want to process all excel workbooks in a directory. Can someone
give me an example?

How do I gather the names of each excel workbooks in the directory?
How do I loop throught them? ie, For each excel workbook

Thank you for any help,
Jeff

 

[Ron de Bruin]

Mayby this will give you some ideas Jeff.
http://www.rondebruin.nl/copy3.htm

You can see how the Dir function is working.
Post back if you need help

 

[Jeff Arledge]

Thank you for the help

Mayby this will give you some ideas Jeff.
http://www.rondebruin.nl/copy3.htm

You can see how the Dir function is working.
Post back if you need help