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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a variable name as part of a file pathname to open many files
Yes this can be done,
use a string variable for the name of the workbooks.open Filename:=strFileName ''where strFileName is a path and file name of the file you want to open, then use the activeworkbook and thisworkbook object to play around with the workbooks and data. Keith www.kjtfs.com -----Original Message----- I need to open 76 Excel files one at a time and copy the data on a tab to a rollup workbook with 76 tabs. Is there a way to build an array with the names of the 76 workbooks and then change the pathname using the 76 names in the array so I can open each workbook, copy the information to the rollup workbook, and close the individual workbooks? The workbooks are too large to open all of them and then copy the data to the rollup workbook! TIA!!:) --- Message posted from http://www.ExcelForum.com/ . |
Reply |
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 |