importing mulitple files

  • Thread starter Thread starter heather
  • Start date Start date
H

heather

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
 
a code like this ?

Workbooks.Open Filename:=ThisWorkbook.Path & "\" & "Myfile1.xls"
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & "Myfile2.xls"

etc....

Bye
 
Back
Top