BZeyger,

Using the macro recorder you can capture this

Workbooks.Open Filename:= _
"<File 1.xls"
Workbooks.Open Filename:="<File 2.xls", UpdateLinks _
:=0
Workbooks.Open Filename:="<File 3.xls", UpdateLinks _
:=0
Workbooks.Open Filename:="<File n.xls", UpdateLinks _
:=0


"BZeyger" wrote:

How do I open 2 or more excel files in one shot? If I create a macro to
launch a diolague box, Is there a way to select numerious .xls files or does
it only have to be performed one at a time?