Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User selection of folder and open all .xls files within folder | Excel Programming | |||
Help: Can open a spreadsheet in a folder which contains spaces in the folder name! | Excel Programming | |||
open file from folder save in new folder | Excel Programming | |||
Macro to Open all workbooks in a folder and change default font | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |