Export a file with today's date

[Grek]

Hello,

I would like to export my excell workbook with today's date as name.

For instance nameofmyexcellsworbook 20040428.xls

No problem to do the export in VBA. The only problem is that I don'
know how to deal with the date...

Even If I put today() in a cell and then export with the value of thi
cell it doesn't work...

Could you help me please ?

Thank you very much in advance,

Gre

 

[gitcypher]

See the attached file. By your post, im sure you can access the cel
value from within VBA and work with it as you please.

-Gitcyphe

Attachment filename: nameofmyexcellsworbook.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52914

 

[David McRitchie]

does
http://www.mvps.org/dmcritchie/excel/backup.htm
answer your question. The following was for a directory

filename = "c:\mybackup\B" & Format(Now(), "yyyy_mmdd") & ".xls"

 

[Tom Ogilvy]

? "ABCD " & format(date,"yyyymmdd") & ".xls"
ABCD 20040429.xls


might give you some ideas.

 

[Grek]

Hi,

Thank you very much for your response.

I ve just tried that and it seems to work :


ActiveCell.Value = Format(Now(), "yyyymmdd")

Thanks again,

Gre

 

[Grek]

Thx a lot !

Greg