I have a button while click export a query report to an excel file.
After file has been exported I just want to want to display a message using msgbox
like "Report file location is C:\test\test.xls"
and it will be a hyperlink so the file can open while click on the hyperlink.
Please advise me vba code for that purpose.