Forum Discussion
Solved
Date_in_VBA
Is there a way I can save date so that the date does not come across a number. I have =today() which gives me the days date. For example, if I save 4/9/2025. The document returns with "nameofdocum...
Thanks for your help. I believe I have what I need.
Thank you
I added the code at the end. I am sure I am something incorrect as it did not work.
This is how I typed it
fName = "PWS_Equipment_" & .Range("G10") & Range("C3").Value2 & Format(Date, "m/d/yyyy")
That should add the date as a date, not as a number...