Saving from a Macro

  • Thread starter Thread starter Shpendi
  • Start date Start date
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
 
Hi
try something like
aqctiveworkbook.saveas "report_weekly_" & format(date,"DD/MM/YY") &
".xls"
 
Back
Top