| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing mulitple files
Hello
I am importing five files into one workbook each one a separate page. Is there a way I can type the file names into five cells and have a macro open the file names I typed? A 1 2 B File Names Test1021.msq C Test1023.msq D Data1021.msq E Data1023.msq F Test1022.msq Basically I need to open the five files listed in column 2. Thanks for any help offered. Heather |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
importing mulitple files
a code like this ?
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & "Myfile1.xls" Workbooks.Open Filename:=ThisWorkbook.Path & "\" & "Myfile2.xls" etc.... Bye "heather" a écrit dans le message de ... Hello I am importing five files into one workbook each one a separate page. Is there a way I can type the file names into five cells and have a macro open the file names I typed? A 1 2 B File Names Test1021.msq C Test1023.msq D Data1021.msq E Data1023.msq F Test1022.msq Basically I need to open the five files listed in column 2. Thanks for any help offered. Heather |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I append multiple sheets from mulitple xls. files. into 1 | Excel Discussion (Misc queries) | |||
| importing data from mulitple files in a directory | Excel Discussion (Misc queries) | |||
| Importing files | Excel Discussion (Misc queries) | |||
| Macro to create mulitple files | Excel Discussion (Misc queries) | |||
| Importing CSV files | Excel Discussion (Misc queries) | |||
Linear Mode
