I am trying have a macro save the current file include the time I saved the file. e.g. 0 Event Request for -- -- -- - - V20090720 18:37:37
The way I have the macro written now results when I try to save the file in an error - incorrect syntax. I believe it is caused by the colon between the numbers that make up the time hh:mm:ss. How can I get the time without the colon so that I can save the file? Maybe hh mm ss?
' Collect current date
strVerDate = Range("Ver_Date")
strFileName = strTest & " Event Request for " & strDate & " - " & strCustomer & " - " & strVerDate
Application.Dialogs(xlDialogSaveAs).Show strFileName
VerDate is =CONCATENATE("V",ED5,ED6,ED7," ",TEXT(ED8,"hh:mm:ss"))
ED8 is =Now()
Bookmarks