Trying to Create a Folder Browser Dialog in my Macro

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • victoryword
    New Member
    • Feb 2014
    • 1

    Trying to Create a Folder Browser Dialog in my Macro

    Currently my code points directly to a directory but I want to be able to give people a choice as to which directory to go to. Any assistance is appreciated:

    Code:
    Dim objFSO
        Set objFSO = CreateObject("Scripting.FileSystemObject")
            
        If bCriminal Then
            CaseFolderPart1 = "N:\Criminal Open\" & Me.TextFirstName.Text
        End If
        If bDefense Then
            CaseFolderPart1 = "N:\Civil Open\" & Me.TextFirstName.Text
        End If
        If bTest Then
            CaseFolderPart1 = "N:\Test\" & Me.TextLastName.Text
        End If
    Last edited by Rabbit; Feb 13 '14, 03:51 AM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
Working...