Automatically saving to someone's 'My Documents' directory

  • Thread starter James Price at Premier
  • Start date
J

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
 
M

Mike H

Try this

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

Mike
 
Top