Extract text from determinate cell with VBA

[ToseSenpai]

Hi all,

If i have this code:

TempFileName = "File name with date: " & Format(Now, "dd-mm-yy")

How can i change the part "Format(Now, "dd-mm-yy")" instead to give the date of today, give me a date in a determinate cell of the "sheet1"

For example:

TempFileName = "File name with date: " & Range("A3")

Thank you all for your help!

 

[Fluff]

How about

TempFileName = "File name with date: " & format(Sheets("Sheet1").Range("A3"),"dd-mm-yy")

 

[ToseSenpai]

How about

TempFileName = "File name with date: " & format(Sheets("Sheet1").Range("A3"),"dd-mm-yy")

Beautiful!!
Thank you very much

Have a good day!

 

[Fluff]

You're welcome & thanks for the feedback.