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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a shortcut to open several excel files? 2
How to maximize the Excel window? 9
Windows 10 How to create individual shortcut for each user 1
Excel shortcut options 0
How to remove listed shortcuts for deleted Excel files? 1
How to create a shortcut to open several files? 5
How do I create a desktop shortcut for a specific .xlsm file? 3
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0

Back
Top