MACRO LIBRARY

Lesson 1.10 homework solution

Free public access. No account or subscription required.

Files

Lesson 1.10 homework solution

Code

Module: mMain

'Homework 1.10
'Create a text file on your desktop called "Test.txt". Then create a folder on your desktop _
    called "Test". Then write a macro that lets you browse to your desktop, then searches for _
    "Test.txt", and then copies the file into the folder called "Test".
    
Dim strFile As String
Dim strFolder As String
    
Sub main()
    strFolder = BrowseFolder("Browse for folder")
    strFile = Dir(strFolder & "\")
    While strFile <> ""
        If InStr(1, strFile, "Test.txt") <> 0 Then
            FileCopy strFolder & "\" & strFile, strFolder & "\Test\" & strFile
        End If
        strFile = Dir
    Wend
End Sub

Module: mBrowseFolder

#If VBA7 Then
    
Private Type BROWSEINFO
hOwner As LongPtr
pidlRoot As LongPtr
pszDisplayName As String
lpszTitle As String
ulFlags As LongPtr
lpfn As LongPtr
lParam As LongPtr
iImage As LongPtr
End Type
    
Private Declare PtrSafe Function SHGetPathFromIDList Lib "shell32.dll" Alias _
            "SHGetPathFromIDListA" (ByVal pidl As LongPtr, _
            ByVal pszPath As String) As LongPtr
            
Private Declare PtrSafe Function SHBrowseForFolder Lib "shell32.dll" Alias _
            "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) _
            As LongPtr
            
Dim X As LongPtr, bi As BROWSEINFO, dwIList As LongPtr
    
#Else
    
Private Type BROWSEINFO
hOwner As Long
pidlRoot As Long
pszDisplayName As String
lpszTitle As String
ulFlags As Long
lpfn As Long
lParam As Long
iImage As Long
End Type
    
Private Declare  Function SHGetPathFromIDList Lib "shell32.dll" Alias _
            "SHGetPathFromIDListA" (ByVal pidl As Long, _
            ByVal pszPath As String) As Long
            
Private Declare  Function SHBrowseForFolder Lib "shell32.dll" Alias _
            "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) _
            As Long
            
Dim X As Long, bi As BROWSEINFO, dwIList As Long
    
#End If
    
Private Const BIF_RETURNONLYFSDIRS = &H1
    
Public Function BrowseFolder(szDialogTitle As String) As String
    
Dim szPath As String, wPos As Integer
    
    With bi
        .hOwner = hWndAccessApp
        .lpszTitle = szDialogTitle
        .ulFlags = BIF_RETURNONLYFSDIRS
    End With
    
    dwIList = SHBrowseForFolder(bi)
    szPath = Space$(512)
    X = SHGetPathFromIDList(ByVal dwIList, ByVal szPath)
    
    If X Then
        wPos = InStr(szPath, Chr(0))
        BrowseFolder = Left$(szPath, wPos - 1)
    Else
        BrowseFolder = vbNullString
    End If
End Function