How to create a shortcut to open several excel files ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to create a shortcut to open several excel files with
only one click?
thank you in advance
Eric
 
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
 
Back
Top