ANSWERS: 1
-
this will only give you for current date. adapt as needed Dim dt As Date, fn As String dt = Now() fn = "johndoe" & Format(dt, "mmddyy") & ".txt" MsgBox fn
Copyright 2023, Wired Ivy, LLC