open all workbooks in a folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
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.
 
Thanks both of you for the links. I found a lot of other useful things also.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted workbooks on startup 2
Excel Protection 2
Macro for all Excel Workbooks to print to PDF 2
Error message 1004 2
Open and close workbooks 1
Active Workbook Path 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0

Back
Top