Is there a simple way in VBA to determine the filesystem path to the user's home (or My Documents) directory?

We have an Excel VBA script that will run on a shared machine that needs to write files to the logged-in user's My Documents. If it complicates the matter any, the user's My Documents are mapped to a Windows file server rather than being located on the local hard drive.

Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.

__________________
Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.

Hi Bruce,

Take a look at this link
http://blogs.officezealot.com/charle...2/10/3574.aspx

I think you can find the answer for your question

-vemaju

Use the WSH objects:
    Set oShell = CreateObject("WScript.Shell")
    sMyDocs = oShell.SpecialFolders("MyDocuments")

rgds
Phil

Thanks, that worked perfectly.

Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.