A few words of thanks would be greatly appreciated.

VBA/VB6 - My Documents + Environment Variables

Latest update on July 30, 2020 at 06:31 AM by David Webb .

The "My Documents" folder path contains a variable username component and changes from one user to another. It is possible to write a code in VBA or VB6 to access the "My Documents" folder regardless of the username, with the help of functions that can read environment variables in VB6. As with every programming language,writing code in VB6 or VBA requires knowledge of basic programming concepts including subroutines, loops, and specific VB6 functions.Environment functions such as Environ$ which receives the value of an environment variable, can be used to write a code to read environment variables in VB6.

With VBA
With VB6
- Environment Functions
- Windows Variables
Note that:

As displayed in Windows Explorer, the My Documents folder appears to be in the root, but this is not the case. It is located in a subdirectory of C:\Documents and Settings. The problem is that this subdirectory takes the user's name and is changed not only from one PC to another, but also on PCs supporting multiple users.The following codes allow you to access the My Documents folder by default regardless of the user logged on.

With VBA

Just paste the following code in a general module:


Option Explicit     
Private Type SHITEMID     
    cb As Long     
    abID As Byte     
End Type     
Private Type ITEMIDLIST     
    mkid As SHITEMID     
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     
To call the function, simply create a  button and paste in the following code:     
Private Sub CommandButton1_Click()     
    Cells(5, 2) = Rep_Documents()     
End Sub

With VB6

Under VB6, use the environment variable UserProfile (this also works with VBA):

Dim sPathUser as String    
sPathUser = Environ$("USERPROFILE") & "\my documents\"    
MsgBox sPathUser

Environment Functions

The Environ$ function is use to receive the value of an environment variable.
For example, when you used the WINDIR command (Windows), you would have obtained the folder where Windows is installed (C:\Windows\).
These variables can be used in batch files, through the Run utility and in a programming environment such as VB and VBA.

Typing % UserProfile% references the current user.
Typing % UserProfile%\My Documents" references the My Documents folder.
Typing %WinDir% gets the Windows folder.
Typing %tmp% gives you access to temporary files.

Windows Variables

Variables for the default user
- TEMP temporary directory
- TMP temporary directory
System variables
- ComSpec variable path for the command prompt.
- FP_NO_HOST_CHECK?
- NUMBER_OF_PROCESSORS?
- OS Returns OS in use.
- Path?
- PATHEXT?
- PROCESSOR_ARCHITECTURE Returns the processor architecture (x86 etc ...)
- PROCESSOR_IDENTIFIER Returns the processor ID.
- PROCESSOR_LEVEL?
- PROCESSOR_REVISION Returns the number of processor revisions
- TEMP temporary directory.
- TMP temporary directory.
- windir folder where Windows is installed.
- SystemRoot folder where Windows is installed.

Note that:

If you are logged in as an administrator, the changes can be made through Control Panel/Advanced System/Environment Variables.
Photo: 123rf.com

Vb6 environment variables
Vb6 environ - Best answers
Environ vb6 - Best answers
Environment variables - Articles
Client server environment - Articles
Vb6 color to rgb - How-To - Visual Basic
Store cell address in variable vba ✓ - Forum - Excel
64 bit variable in c - How-To - C Language

This document, titled « VBA/VB6 - My Documents + Environment Variables », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Pascal Language - Screen management

Pascal Language - Shift array of elements (Rotation)-Recursion

With VBA

With VB6

Environment Functions

Windows Variables

Note that:

Subscribe To Our Newsletter!