Opening the most recent file saved to a folder

Hi Folks,

I am trying to use the code below to open the most recently saved file in my downloads folder, however it is returning an error that it can't find it. I believe this is because the code is including the file extension ".xls" in the name search.. I am wondering if someone can confirm this and help augment the code so that it drops the file extension from the name?

Thanks in advance for all posts

Please Login or Register  to view this content.

Hi there,

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

Please Login or Register  to view this content.

The most significant change from your original code is in the highlighted line.

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

Regards,

Greg M

Hi again,

Many thanks for the Reputation increase

Regards,

Greg M