Hi,
I have a macro to export the report I created as a PDF, and it works perfectly fine. However, I would like to take away the 1 last option for user error and have it automatically name it "Weekly Report" and the current date.
I have tried the following in the 'Output File' section of the macro builder:
E:\Folder\AnotherFolder\Weekly Report & "_" & Format(Date(),"yyyy_mm_dd")
and this didn't work.
Any ideas?
Thanks
I have a macro to export the report I created as a PDF, and it works perfectly fine. However, I would like to take away the 1 last option for user error and have it automatically name it "Weekly Report" and the current date.
I have tried the following in the 'Output File' section of the macro builder:
E:\Folder\AnotherFolder\Weekly Report & "_" & Format(Date(),"yyyy_mm_dd")
and this didn't work.
Any ideas?
Thanks