need to open latest excel workbook automatically

[clammastak]

I have been using the following code successfully for a while now. Upon activation of macro, the program prompts the user to open an excel file , with the specific folder path already open. From there, the user double clicks (opens) the selected file and the programming continues. However, I would like to modify it slightly so the user DOES NOT have to select his/her own file, but Excel will just automatically find the newest file with "Date Last Modified" (usually the first file on top in my share drive) upon activation. Can anyone assist me? It seems relatively simple but couldn't get any short and concise responses online.

Please Login or Register  to view this content.

[Greg M]

Hi there,

Try the following code and see if it does what you need:

Please Login or Register  to view this content.

The highlighted value can be changed to suit your requirements.

The above routine will open the file most recently modified in the specified folder. It assumes that the most recently modified files in the folder will always be Excel workbooks.

Hope this helps - please let me know how you get on.

Regards,

Greg M