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"