open all workbooks in a folder
 

How can i open all workbooks (the number & name of workbooks may be
different) in a specific folder with one macro.
The path can be made dynamic by using "ThisWorkbook.Path"

open all workbooks in a folder
 

Have a look he
http://www.vbaexpress.com/kb/getarticle.php?kb_id=733

"Amit" wrote in message
...
How can i open all workbooks (the number & name of workbooks may be
different) in a specific folder with one macro.
The path can be made dynamic by using "ThisWorkbook.Path"

open all workbooks in a folder
 

Hi Amit,

In addition to Corey's suggestion, Ron de Bruin has numerous
examples at:

Copy/Paste/Merge examples
http://www.rondebruin.nl/tips.htm

According to your requirements, it may not be necessary to
open the files and Ron also provides sample code to interrogate
closed files.


---
Regards,
Norman


"Amit" wrote in message
...
How can i open all workbooks (the number & name of workbooks may be
different) in a specific folder with one macro.
The path can be made dynamic by using "ThisWorkbook.Path"

open all workbooks in a folder
 

Thanks both of you for the links. I found a lot of other useful things also.


"Coza" wrote:

Have a look he
http://www.vbaexpress.com/kb/getarticle.php?kb_id=733

"Amit" wrote in message
...
How can i open all workbooks (the number & name of workbooks may be
different) in a specific folder with one macro.
The path can be made dynamic by using "ThisWorkbook.Path"