Automatically saving to someone's 'My Documents' directory

[James Price at Premier]

Is there a default that saves a file to someone's 'my documents' directory as
two people in the same dept will have different directory paths.

Many thanks

James

 

[Mike H]

Try this

MyPath = CreateObject("WScript.Shell").Specialfolders("MyDocuments")

Mike

 

[James Price at Premier]

That's great. Thanks Mike

James

Try this

MyPath = CreateObject("WScript.Shell").Specialfolders("MyDocuments")

Mike

 

[Mike H]

Your welcome and thanks for the feedback

That's great. Thanks Mike

James