Looking for Excel VBA Example
 

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

Looking for Excel VBA Example
 

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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Jeff Arledge" wrote in message om...
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

Looking for Excel VBA Example
 

Thank you for the help

"Ron de Bruin" wrote in message ...
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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Jeff Arledge" wrote in message om...
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