Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'My Documents' (2000-2003)

    I need to save documents to different subfolders under the My Documents folder in a Word macro using ActiveDocument.SaveAs ...how do I reference the My Documents folder? This macro will run on every employee's system and it needs to reference My Documents globally.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: 'My Documents' (2000-2003)

    Here is one method:

    Dim strMyDocs As String
    strMyDocs = CreateObject("WScript.Shell").SpecialFolders("MyDo cuments")

  3. #3
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'My Documents' (2000-2003)

    Thank you again, Hans, worked like a charm!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •