Automatically open files at the specific location

[geniusufo007]

C:\Users\genius\AppData\Roaming\Microsoft\Excel\XLSTART
I HAVE THREE EXCEL WORKBOOKS IN THE ABOVE PATH, SO WHEN I OPEN EXCEL APPLICATION, IT OPEN THE THREE FILE AUTOMATICALLY, BUT IF I HAVE THE ABOVE FILES IN PARTITION D IN A SPECIFIC LOCATION THEN HOW DO I ACHIEVE THE SAME GOAL IN THIS CASE, PLEASE HELP

[Zer0Cool]

You can try putting shortcuts to those files in the XLSTART folder. Ive never tried it but it might work. You could otherwise place in your personal workbook in the workbook_open event VBA code to open the workbooks you want to open. I personally would recommend you find a way to do it without VBA.

Check here too, Google to the rescue:

https://support.office.com/en-us/art...b-779df08957a3

Looks like you can set files to startup with Excel in basically any location.

[geniusufo007]

Thank you sir, it is working