i'm trying to get excel macro to enter the title of my excel with the title + date on a cell.
The date on the cell is in ddmmyy (custom) format. e.g. 130608
I put in the follow:
ActiveWorkbook.Names.Add name:="cobdate", RefersToR1C1:= _
"=R2C4"
Dim date As String
date = Range("titledate")
Range("A2").Value = "title" & date
however, after running the macro, the result is "title 13/06/08".
how do i get the macro to use the date as 130608 without the slashes?
I need to do away with the slashes because after this I have another macro to save the file using the title, which slashes are not permitted in filenames.
Anyone have any good suggestions pls?
Thanks in advance.
The date on the cell is in ddmmyy (custom) format. e.g. 130608
I put in the follow:
ActiveWorkbook.Names.Add name:="cobdate", RefersToR1C1:= _
"=R2C4"
Dim date As String
date = Range("titledate")
Range("A2").Value = "title" & date
however, after running the macro, the result is "title 13/06/08".
how do i get the macro to use the date as 130608 without the slashes?
I need to do away with the slashes because after this I have another macro to save the file using the title, which slashes are not permitted in filenames.
Anyone have any good suggestions pls?
Thanks in advance.