Access Export file name with userprofile variable

New Contributor

Does anyone know if there is a way to set an export file name, in an export macro, based on the windows login ID location.  Something like

C:\users\%userprofile%\........ so it saves to each particular users folder location for whoever does the export.


That format works in dos prompt but doesn't work in the macro.


(This is in a macro not in the code using docmd)

3 Replies



can you create a Function that will return you the Path + filename:

in a Module, add this code:

Public Function MyDocumentFile(ByVal filName As String) As String
MyDocumentFile = Environ$("userprofile") & "\documents\" & filName
End Function


then you can call the function from your Macro:



best response confirmed by Barry_R (New Contributor)



Thank you that worked and you provided all the info clearly for me to follow. 

Extremely helpful! - much gratitude for your insightful example!