Hello All,

I'm trying to add the user name(windows login ID) to the two txt files from the code. Any help would be great!!


sLANPath = "C:\Macro Message Files\"
reportdate=CVar(Date)
hypendate = Format(reportdate,"mm-dd-yyyy")
EffectiveDate = Format(reportdate, "mm/dd/yyyy")

open sLANPath & "ErrorMessage NPN -" & hypendate & ".txt" for APPEND as #2 'file contains Errors'
open sLANPath & "Processed NPN -" & hypendate & ".txt" for APPEND as #3 'file contains processed good'