Macro to save file with today's date in the filename

I have a macro that saves a file to a specific location and need to include today's date as part of the filename...

eg - C:\MyDirectory\Worksheet - Today's Date.xlsm

I've tried this but it doesn't work:

Please Login or Register  to view this content.

Appreciate any help - thanks!

The date must be outside the quotes....

Please Login or Register  to view this content.