Hello, I want to be able to refer to a user's 'MyDocuments' folder -
whatever operating system/network/etc. they are using.

Is there a way to refer to it that isn't dependant on their setup?

Thanks

M

I use:

Dim myDocumentsPath As String

myDocumentsPath = CreateObject("WScript.Shell") _
.SpecialFolders.Item("mydocuments")

MsgBox myDocumentsPath

Michelle wrote:

Hello, I want to be able to refer to a user's 'MyDocuments' folder -
whatever operating system/network/etc. they are using.

Is there a way to refer to it that isn't dependant on their setup?

Thanks

M

--

Dave Peterson

Not bad! - that seems to do just what I want. Thank you

M


"Dave Peterson" wrote in message
...
I use:

Dim myDocumentsPath As String

myDocumentsPath = CreateObject("WScript.Shell") _
.SpecialFolders.Item("mydocuments")

MsgBox myDocumentsPath

Michelle wrote:

Hello, I want to be able to refer to a user's 'MyDocuments' folder -
whatever operating system/network/etc. they are using.

Is there a way to refer to it that isn't dependant on their setup?

Thanks

M

--

Dave Peterson

Dave,

Thanks for the tip! I've used the environ("user") and put that in an
explicit path but like your suggestion.

On Mon, 30 Nov 2009 07:46:18 -0600, Dave Peterson
wrote:

I use:

Dim myDocumentsPath As String

myDocumentsPath = CreateObject("WScript.Shell") _
.SpecialFolders.Item("mydocuments")


John Keith