Save File with TimeStamp

Hi All, I've got the below code which gives me "Type mismatch" on 'CStr'. Would you be so kind please and advise as to how I can save this file so that it follows the outlined format below?

Please Login or Register  to view this content.

Many thanks!

Hi Frennzyy

You can't have filenames with a colon ":" character in it.
Change it to a space or a dash character.
How about
timeStamp = format(Now, "dd-mm-yy hh-mm")
fileName = "Test - " & Worksheets("MainTab").Range("E4").Text & "@" & timestamp

zeddy

Hi zeddy, thanks for the reply.
Please note that I did as you said but now I'm getting "Compile error: Wrong number of arguments or invalid property assignment" on 'format'.

Thanks!

this format works for me

Please Login or Register  to view this content.