Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links

How To Find the directory of My Documents [VBA/VB6]

Tips & Tweaks

Thread Tools Search this Thread
Old 02-09-2008
Join Date: Aug 2005
Posts: 293
How To Find the directory of My Documents [VBA/VB6]

Find the directory of My Documents

In the file explorer the My Documents folder appears to be on the root or this is not the case, it is located in a sub directory C: \ Documents and Settings the bottom line is that the first sub directory takes username and change not only from one PC to another, but also on a multi PC users.
The following code allows for the My Documents directory of whatever the user connected.
Paste this code in a general module.

Option Explicit Private Type ****EMID cb As Long abID As Byte End Type Private Type ITEMIDLIST mkid As ****EMID End Type Private Const CSIDL_PERSONAL As Long = &H5 Private Declare Function SHGetSpecialFolderLocation Lib "shell32.dll" _ (ByVal hwndOwner As Long, ByVal nFolder As Long, _ pidl As ITEMIDLIST) As Long Private Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias "SHGetPathFromIDListA" _ (ByVal pidl As Long, ByVal pszPath As String) As Long Public Function Rep_Documents() As String Dim lRet As Long, IDL As ITEMIDLIST, sPath As String lRet = SHGetSpecialFolderLocation(100&, CSIDL_PERSONAL, IDL) If lRet = 0 Then sPath = String$(512, Chr$(0)) lRet = SHGetPathFromIDList(ByVal IDL.mkid.cb, ByVal sPath) Rep_Documents = Left$(sPath, InStr(sPath, Chr$(0)) - 1) Else Rep_Documents = vbNullString End If End Function
Sample call: In a leaf paste a button and the button code.

Private Sub CommandButton1_Click() Cells(5, 2) = Rep_Documents() End Sub
More single VB6
Sub VB6, you just have to exploit the environment variable UserProfile:
"%UserProfile%\My documents
Without including quotes.

Reply With Quote

  TechArena Community > Software > Tips & Tweaks
Tags: , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "How To Find the directory of My Documents [VBA/VB6]"
Thread Thread Starter Forum Replies Last Post
I want to change the directory of Chrome which is installed in Documents and Settings? Joyendu Technology & Internet 8 28-02-2012 09:33 AM
Unable to find mail notes which were stored as documents Eduards Operating Systems 4 03-03-2011 11:29 AM
Windows cannot find C\Documents Aspen Operating Systems 4 03-08-2009 11:08 PM
Command to find size of a directory ThunDer_22 Software Development 2 17-06-2009 02:14 PM
Firefox Add-on: Find and Download Documents with OutWit Docs Spykar Tips & Tweaks 1 09-04-2009 06:26 PM

All times are GMT +5.5. The time now is 06:10 PM.