Set "My Documents" Path

[jhrBanker]

I create and share db's with others in my group. Most of these db's have VBA code for importing and exporting files. My VBA code contains the Path to the "My Documents" folder (C:\Documents and Settings\{MYID}\My Documents\Access). Whenever I share the db's, I go in and globally change {MYID} to the target users ID. I've changed the code in my most recent db to "%USERPROFILE%\My Documents\Access", and it's working in most situations. However, it doesn't seem to work with the DoCmd.TransferText statement. Any suggestions as to how I can get around this?

[Access_Blaster]

take a look at this example DB. Open it up in design view and look at the code behind the buttons. It defaults to the My Documents folder

[jhrBanker]

Thanks, but I don't believe you've answered my question. I want to use a folder below "My Documents" (My Documents\Access, etc). Also, although your example points to the My Documents folder, I don't see anything in your code that causes that:
Private Sub Xfer_text_btn_Click()
DoCmd.TransferText acExportDelim, "Inventory_Specs", "M_Inventory", "Inventory.csv"
End Sub
Can you help me to understand?

[Access_Blaster]

I am sorry I did miss that "My Documents\Access" how about using a dialog box ? this can be edited.

http://www.mvps.org/access/api/api0001.htm

[Access_Blaster]

Try this now I put in the dialog box for you.

[jhrBanker]

This should work fine. Thanks for your help. Muchly appreciated!

[Access_Blaster]

That can be used for importing this is what you might use as an export.

DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Documents and Settings\Administrator\My Documents\access\my.csv


Richard