Adding Today's Date to a Filename

Hello, I am using Excel 2003 in Windows XP. I have written a macro to save my active workbook to my home drive. However, I need to add today's date to the workbook's filename.

The following code saves my workbook named: Letters Not Sent - Contractor - within Australia (ready for Mail Merge).xls

ActiveWorkbook.SaveAs ("C:\EXCEL\Letters Not Sent - Contractor - within Australia (ready for Mail Merge).xls")

I need the workbook's file name to look the following example (assuming today's date is the 07 Dec 12):

Letters Not Sent - Contractor - within Australia (ready for Mail Merge) (07 Dec 12).xls

I do not know how to add today's date to the filename?

Could someone kindly assist me - it would be greatly appreciated.

Kind regards,

Chris

Please Login or Register  to view this content.

You are quite welcome. thanks for the feedback.