Cancantenate Date to Output File

[NeonSky via AccessMonster.com]

Hello All!

I am attempting to cancantenate the present date to the end of a file within
a macro's output file field.

It is presently not working, and this is how it looks...

F:/NewPeople/XGCardRonLetter"& Format(Date(),"mmddyyyy") & ".xls"

Thank you!!

 

[pietlinden]

try Name... see the help file.

 

[John Nurick]

Try

="F:\NewPeople\XGCardRonLetter" & Format(Date(),"mmddyyyy") & ".xls"

 

[NeonSky via AccessMonster.com]

Thanks John works perfect!!

Try

="F:\NewPeople\XGCardRonLetter" & Format(Date(),"mmddyyyy") & ".xls"

Hello All!

[quoted text clipped - 6 lines]

Thank you!!