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

Try this

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

Mike

"James Price at Premier" wrote:

> 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

That's great. Thanks Mike

James

"Mike H" wrote:

> Try this
>
> MyPath = CreateObject("WScript.Shell").Specialfolders("MyDocuments")
>
> Mike
>
> "James Price at Premier" wrote:
>
> > 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

Your welcome and thanks for the feedback

"James Price at Premier" wrote:

> That's great. Thanks Mike
>
> James
>
> "Mike H" wrote:
>
> > Try this
> >
> > MyPath = CreateObject("WScript.Shell").Specialfolders("MyDocuments")
> >
> > Mike
> >
> > "James Price at Premier" wrote:
> >
> > > 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