VBA code to open, save, refresh, save and close excel file with dynamic path

[whyjaydee]

Hi vba experts,

I have an excel file that will be used by different people in different places.
Basically, I need to file to open, refresh all, save, and close.

If it's possible to have the file saved using the user's path directory.

Thank you in advance and all kinds of help will be appreciated!