DeanP
12-21-2018, 03:19 PM
I am trying to get a list of files in a folder using GetFolder.
I have declared myFolder as below, now I want to set my folder with MyFSO.GetFolder("______")
My folder path is in a text box (TextBox5) in the userform. How do I reference that text box in my macro?
Dim MyFSO As FileSystemObject
Dim MyFile As File
Dim MyFolder As Folder
Set MyFSO = New Scripting.FileSystemObject
Set MyFolder = MyFSO.GetFolder(??)
I have declared myFolder as below, now I want to set my folder with MyFSO.GetFolder("______")
My folder path is in a text box (TextBox5) in the userform. How do I reference that text box in my macro?
Dim MyFSO As FileSystemObject
Dim MyFile As File
Dim MyFolder As Folder
Set MyFSO = New Scripting.FileSystemObject
Set MyFolder = MyFSO.GetFolder(??)