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.
 

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
Active Workbook Path 2
Open and close workbooks 1
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