Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Find location of “My Documents” with VBA in Windows 7

Posted on 2010-09-13
10
Medium Priority
?
3,548 Views
Last Modified: 2012-05-10
Because my drive C: was getting too filled, I moved "My Documents" from its usual location of

                “C:\Documents and Settings\" & Environ("USERNAME") & "\" & “My Documents”

to the same location on drive “F:”

     I would like to have VBA be able to recognize where the new location of “My Documents” is. Other persons who use my programs may also have moved the location of “My Documents,” so any suggestions as to how VBA can find that folder would be most welcome.

     Note: my Windows Explorer indicates that drive C: still has a directory named “Documents and Settings” but if one clicks on it, a message appears that the directory is not accessible.

     I suppose one could check each drive for the existence of a “My Documents,” but I do not know how to make a loop that could look at each drive on a computer.

          Thanks, as always, for your help
          John Robin
0
Comment
Question by:JohnRobinAllen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 3

Expert Comment

by:Fixforyou
ID: 33662888
Did you use the properties page to move the my documents folder?  The actual path is now {DRIVELETTER}:\Users\{username}\   if I remember correctly.  Your script will have to point to that location I would think, but then it would be pointed to a symbolic link.
movedocuments3.png
0
 
LVL 3

Expert Comment

by:danlein
ID: 33662900
Can't you just put it in a library ?
0
 
LVL 3

Expert Comment

by:Fixforyou
ID: 33662915
Oppps, forgot to add the string variable
%HOMEPATH%\My Documents

see what that does
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 3

Expert Comment

by:d_willia
ID: 33662960
Here is the reg entry for the setting:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\Personal
 
0
 
LVL 3

Expert Comment

by:Fixforyou
ID: 33663025
if "%HOMEPATH%\My Documents" does not work make sure you have ownership of the drive or files...

For taking ownership of files, rightclick them, Security
tab, Advanced, Owner tab. In Name list select Administrator or Admin-group and click OK. Click Add and in the "Enter the object...list" type a user or group account or Administrator. Click OK. In the group or user name list, click the account you want (e.g. Administrator), then tick the check boxes for permissions, e.g. Full Control [Allow].
0
 
LVL 2

Expert Comment

by:FEOX
ID: 33675065
Assuming you did move the My Documents folder using Fixforyou's method (or through registry or through Environment variables), here is a VBA code that retrieves the "My Documents" folder of the current user:
'Set MyDocsPath to Current User's My Documents Folder:
Dim WshShell As Object
Dim MyDocsPath
Set WshShell = CreateObject("Wscript.Shell")
Set MyDocsPath = WshShell.SpecialFolders("MyDocuments")
Set WshShell = Nothing

'Display MyDocsPath:
MsgBox "My Documents folder: " & MyDocsPath

'More info here:
'http://msdn.microsoft.com/en-us/library/0ea7b5xe(VS.85).aspx

Open in new window

0
 

Author Comment

by:JohnRobinAllen
ID: 33677054
I am very excited about all the suggested solutions and will get back to EE probably tomorrow to describe the results. Many thanks for all this help. I wish that other commitments were not preventing me from responding today.
       john robin
0
 

Author Comment

by:JohnRobinAllen
ID: 33686322
I tried FEOX's code and it crashes on line 5:
     Set MyDocsPath = WshShell.SpecialFolders("MyDocuments")
A message appears "Run time error '13'"   Type mismatch.

I do not understand how to translate the other comments into VBA code to run on another user's machine.

     I hope the problem is solvable.

    j.r.a.




0
 
LVL 2

Accepted Solution

by:
FEOX earned 1000 total points
ID: 33687259
Oops, try removing the "Set " on that line:

Use this, instead:
'Set MyDocsPath to Current User's My Documents Folder:
Dim WshShell As Object
Set WshShell = CreateObject("Wscript.Shell")
MyDocsPath = WshShell.SpecialFolders("MyDocuments")  'Don't use Set
Set WshShell = Nothing

'Display MyDocsPath:
MsgBox "My Documents folder: " & MyDocsPath

'More info here:
'http://msdn.microsoft.com/en-us/library/0ea7b5xe(VS.85).aspx

Open in new window

0
 

Author Closing Comment

by:JohnRobinAllen
ID: 33704748
The solution works like a charm, but needs one small change for those of us who like to use "Option Explicit."

I added the line
     Dim MyDocsPath As String
and the code works perfectly.

Many, many thanks for such an easy-to-implement solution
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question