| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
