Saving from a Macro

S

Shpendi

Hi all
I have created a macro to run a report that i do weekly,
Is there a way to make the macro pick up the TODAYS date
when the macro is saved.
e.g report_weekly_06/08/04.xls
does any one know the code?


Thanks
Shpendi
 
F

Frank Kabel

Hi
try something like
aqctiveworkbook.saveas "report_weekly_" & format(date,"DD/MM/YY") &
".xls"
 
Top