Find "my document" folder path

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan Taylor - 14 Sep 2006 03:06 GMT

I am attempting to find the path of the "my document" folder via VBA.
The folder has been redirected and in some cases renamed so I can't just
assume that it is located in the usual location.
Any guidance on locating this path in VBA would be greatly appreciated.

Signature

sallisontaylor

Reply to this Message

Helmut Weber - 14 Sep 2006 15:05 GMT

Hi Susan,

like this:

Dim sTmp As String
Dim wshShell
Set wshShell = CreateObject("WScript.Shell")
sTmp = wshShell.SpecialFolders("MyDocuments")
MsgBox sTmp

Note that there is no space in "MyDocuments" here.

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Reply to this Message

Susan Taylor - 15 Sep 2006 01:25 GMT

Helmut,
Thank you - you make it seem so simple.
this works perfectly!

Signature

sallisontaylor

> Hi Susan,
>
[quoted text clipped - 7 lines]
>
> Note that there is no space in "MyDocuments" here.

Reply to this Message