ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to create a shortcut to open several excel files ? (https://www.excelbanter.com/excel-discussion-misc-queries/114032-how-create-shortcut-open-several-excel-files.html)

Eric

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

CLR

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


Eric

How to create a shortcut to open several excel files ?
 
Thank everyone for suggestions
Eric


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com