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

Answerbag | Terms of Service | Privacy Policy