Add windows user name to exported file

[RE_]

Hi all,

I'm using the below to export a query:



Private Sub Form_Close()
Dim sFilename As String
sFilename = "path\data_dump.csv"
DoCmd.TransferText acExportDelim, , "data_dump", sFilename, True
End Sub

How can I dynamically add the to the file name "data_dump.csv" the windows user name of the user that is actually running the above? Something like "user1_data_dump.csv". If someone else runs the above it could be "user4_data_dump.csv".

Thanks!!

[June7]

Can use Environ("USERNAME") to pull Windows login username.

[RE_]

great, thanks June7!