| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a variable name as part of a file pathname to open many files
I need to open 76 Excel files one at a time and copy the data on a ta
to a rollup workbook with 76 tabs. Is there a way to build an arra with the names of the 76 workbooks and then change the pathname usin the 76 names in the array so I can open each workbook, copy th information to the rollup workbook, and close the individual workbooks The workbooks are too large to open all of them and then copy the dat to the rollup workbook! TIA!!: -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a hyperlink to open a file with part of the name | Excel Worksheet Functions | |||
| can I remove part of a file name (LO) from a group of excel files | Excel Discussion (Misc queries) | |||
| Using a variable to represent the pathname in a formula | Excel Discussion (Misc queries) | |||
| OFFICE PROFESSIONAL 2003 W32, part# 269-08393,will not open files | Excel Discussion (Misc queries) | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Threaded Mode
