View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default How to create a shortcut to open several excel files ?

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



"Eric" wrote:

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