Macro to Save As a file with a date in dd-monthname-yyyy

[witcomm]

Hi

Can you suggest me a macro which will save a new workbook created using a macro in this particular format:

"Filename dd-monthname(3digits only)-yyyy"

Example: "Alarm Logs 16-Mar-2012"

If the month name is not possible for three digits, it can be as "Alarm Logs 16-March-2012" but the capital letter for month is important.


Any help would be appreciated.

Thank you in advance