Amend MsgBox text to include path of file i.e. which folder it is save in

Hi,

I have the following code that automatically saves my workbook i.e. Milestones Report as ‘Milestones Report (dd-mm-yyyy).xlsx’ where dd-mm-yyyy is todays date i.e.

Please Login or Register  to view this content.

then have the following code that displays a message to say the file has been saved successfully i.e.

Please Login or Register  to view this content.

Can anyone please advise me how to amend the code to include the path of the folder where the ‘Milestones Report (dd-mm-yyyy).xlsx’ is saved?

Any assistance in this matter would be greatly appreciated

Many thanks in advance

Regards

Rob

Try something like:

Please Login or Register  to view this content.

Olly,

many thanks for your assistance, the code is exactly what I required!

Thanks again

Regards

Rob

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.