| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export a file with today's date
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 -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Export a file with today's date
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" --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Grek " wrote in message ... 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't know how to deal with the date... Even If I put today() in a cell and then export with the value of this cell it doesn't work... Could you help me please ? Thank you very much in advance, Greg --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Export a file with today's date
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 -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Export a file with today's date
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 -- Message posted from http://www.ExcelForum.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Export a file with today's date
? "ABCD " & format(date,"yyyymmdd") & ".xls"
ABCD 20040429.xls might give you some ideas. -- Regards, Tom Ogilvy "Grek " wrote in message ... 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't know how to deal with the date... Even If I put today() in a cell and then export with the value of this cell it doesn't work... Could you help me please ? Thank you very much in advance, Greg --- Message posted from http://www.ExcelForum.com/ |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Export a file with today's date
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| How to use Today's date in a cell and make it stay the same date | Excel Discussion (Misc queries) | |||
| Reading File Name in VB Macro that contains today's date | Excel Discussion (Misc queries) | |||
| How do I export xml file and keep the date. | Excel Discussion (Misc queries) | |||
Hybrid Mode
