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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tagging Misspell Words with "##" 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
VBA word change keys 0
Clearing Fields in a Word Form 5
Improving Macro That Keeps First Letter 0
Consolidation Table from Different Excel Tabs with Different Format 1
Close all without saving and exit without prompts 8
Macro to Select text from a point given to a specific word 2

Top