Find "My Documents" with VBA macro

[Onno B.]

We use folder redirection for the My Documents (\\server\share\department)
With Word XP (2002) I need to create an macro wich saves some new documents
to \\server\share\department\files. Therefore I need to 'know' where "My
Documents" is redirected to. How can I find this, so far my best solutions
was to use Dialogs(wdDialogToolsOptionsFileLocations).Setting but users can
change this to a folder of their choice which makes it useless.

btw: the 'department' is different for each department...
-- MCSE Admin for medium organisation

 

[Bob Buckland ?:-\)]

Hi Onno,

You may want to use the link below to also post this in the Word VBA discussion group using the link below.

==========We use folder redirection for the My Documents (\\server\share\department)
With Word XP (2002) I need to create an macro wich saves some new documents
to \\server\share\department\files. Therefore I need to 'know' where "My
Documents" is redirected to. How can I find this, so far my best solutions
was to use Dialogs(wdDialogToolsOptionsFileLocations).Setting but users can
change this to a folder of their choice which makes it useless.

btw: the 'department' is different for each department...
-- MCSE Admin for medium organisation >>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.vba.general
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.vba.general

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com