Save as PDF options on Filename

[ljm]

Is there a way to specficy the PDF report name as Weekly Report & today's date as the actual name, some MS variable or something you can use? It would be very helpful, otherwise it seems like the user will have to go in and rename the report so they don't keep getting written over.

Thanks

[mr_vodka]

See Here

Naming PDFs

[ljm]

Thank you for this lead. I have made some variables in my script as recommended, but I am using the variable Get(CurrentDate) which appends the date 4/4/2007 which seems to pose a problem, those slashes don't get interpreted correctly. (I think)

This is the concatenated variable

$FullFileName S:DEVELOPMENTBAILIS FUND2007 dinnerWeekly Fin Reports Weekly_Report_4/4/2007.pdf

which then generates an error message -

"2007.pdf" could not be created on disk. Use a different name, make more room on the disk, unlock it or use a different disk"

I see that this is related to the directory overall, based on the earlier post, but I can't get the file name right either. Is it the slashes?

[mr_vodka]

Why not save it is as something like Weekly_Report_4_4_2007.pdf?

$FileName = "Weekly_Report_" & Substitute ( Get ( CurrentDate ); "/"; "_" )