Macro Save workbook to PDF with filename ddmmyyyy

[david_andrews]

Hi there,

I am still very new to VBA in Excel and would like your help.

I have been searching for a macro to save my workbook to a pdf with the file name generated as ddmmyyyy, for user to then save in a file of their choice.
I have found many that do part of this function or single sheets but nothing applicable to my workbook.

Apologies in advance if this is a dumb question,

Thanks for any and all assistance

(using excel 07)