Date in the workbook name
 

Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you can
have a - so I could put the date in as 8-2-2009 for instance. So I am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.

Also is there a way to just add a day to a date, so that I could name
the next workbook 8-3-2009.

Thanks

Date in the workbook name
 

A & S wrote:
Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you can
have a - so I could put the date in as 8-2-2009 for instance. So I am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.

Also is there a way to just add a day to a date, so that I could name
the next workbook 8-3-2009.

Thanks


In general you can format the date in a cell like this
Format(Range("A1"), "m-d-yyyy")

or this
Format(Range("A1") + 1, "m-d-yyyy")

Date in the workbook name
 

A & S;438621 Wrote:
Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you can
have a - so I could put the date in as 8-2-2009 for instance. So I am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.

Also is there a way to just add a day to a date, so that I could name
the next workbook 8-3-2009.

ThanksHow about this:
Code:
--------------------
ThisWorkbook.SaveAs (ThisWorkbook.Name & " - " & Format(Sheets("Sheet1").Range("A1").Value, "dd-mm-yy") & ".xls")
--------------------


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121716

Date in the workbook name
 

On Aug 1, 6:00*pm, smartin wrote:
A & S wrote:
Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you can
have a - so I could put the date in as 8-2-2009 for instance. So I am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.

Also is there a way to just add a day to a date, so that I could name
the next workbook 8-3-2009.

Thanks

In general you can format the date in a cell like this
* *Format(Range("A1"), "m-d-yyyy")

or this
* *Format(Range("A1") + 1, "m-d-yyyy")

Everytime that I try to use this expression it gives me the error
"Expected ="

Thanks

Date in the workbook name
 

How are you using it? it should be used like this in VBA
Code:
--------------------
ThisWorkbook.SaveAs (ThisWorkbook.Name & " - " & Format(Sheets("Sheet1").Range("A1").Value, "dd-mm-yy") & ".xls")
--------------------


A & S;438636 Wrote:
On Aug 1, 6:00*pm, smartin wrote:
A & S wrote:
Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you
can
have a - so I could put the date in as 8-2-2009 for instance. So I
am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as
the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.

Also is there a way to just add a day to a date, so that I could
name
the next workbook 8-3-2009.

Thanks

In general you can format the date in a cell like this
* *Format(Range("A1"), "m-d-yyyy")

or this
* *Format(Range("A1") + 1, "m-d-yyyy")

Everytime that I try to use this expression it gives me the error
"Expected ="

Thanks


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121716

Date in the workbook name
 

A & S wrote:
On Aug 1, 6:00 pm, smartin wrote:
A & S wrote:
Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you can
have a - so I could put the date in as 8-2-2009 for instance. So I am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.
Also is there a way to just add a day to a date, so that I could name
the next workbook 8-3-2009.
Thanks
In general you can format the date in a cell like this
Format(Range("A1"), "m-d-yyyy")

or this
Format(Range("A1") + 1, "m-d-yyyy")

Everytime that I try to use this expression it gives me the error
"Expected ="

Thanks

Sorry, my wording there was terrible. I should have said,

In general, you can format a date from a cell as a string in VBA like
this...

Then you can use that formatted string to save your worksheet. The Code
Cage Team has you covered.

Date in the workbook name
 

Hello,

Assume in A1 you have 8/12/2009
Then:
Concatenate(month(a1),"-",day(a1),"-",year(a1))

Gabor
"A & S" wrote in message ...
Hi
I am trying to input the date into the title of the my workbook. I
know that you can not have a / in the title of a workbook but you can
have a - so I could put the date in as 8-2-2009 for instance. So I am
wondering is anyone knows how to get a date value from a cell that
would look like 8/2/2009 and then take that date and put it in as the
title of a workbook, but have it formatted such that it would look
like 8-2-2009.

Also is there a way to just add a day to a date, so that I could name
the next workbook 8-3-2009.

Thanks