| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto open and add spreadsheet
Perhaps you want something like this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=221 and then something like this (or maybe you don't need this one): http://www.vbaexpress.com/kb/getarticle.php?kb_id=151 ******************* ~Anne Troy www.piersontech.com www.mrexcel.com "broogle" wrote in message oups.com... Hi, Anybody knows how to open xls file, close it and open the next file. Ok, this is the case: I have some xls files in folder c:\mysummary. All of these files have similar format and formulas. I want to create a macro to open these file one by one, copy some of the sheets in each file and add them to the new xls file, at the end I will get a file as a summary from all files in that directory. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet will not open without Excel Application being open fir | Excel Discussion (Misc queries) | |||
| Auto Open | Excel Discussion (Misc queries) | |||
| auto open, auto close | Excel Programming | |||
| Auto Open | Excel Programming | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
![Anne Troy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
