How to create a shortcut to open several excel files ?

E

Eric

Does anyone know how to create a shortcut to open several excel files with
only one click?
thank you in advance
Eric
 
C

CLR

This macro should do it, of course it will have to be modified to your
conditions.......

Sub OpenSeveralFiles()
Workbooks.Open FileName:="C:\FileOneName.xls"
Workbooks.Open FileName:="C:\FileTwoName.xls"
Workbooks.Open FileName:="C:\FileThreeName.xls"
End Sub

hth
Vaya con Dios,
Chuck, CABGx3
 
Top