Hi,
have the code below how can I modify to that instead listing the path (folder location) when i click prompt for selection prompt me to select folder.
thank you
have the code below how can I modify to that instead listing the path (folder location) when i click prompt for selection prompt me to select folder.
VBA Code:
Sub LISTFILES()
Dim MyFolder As String
Dim MyFile As String
Dim j As Integer
MyFolder = "C:\Users\jose.rossi\Documents\FOR POSTING\OCT 19\COGS\PEERLESS NETWORK\909_WESTEL"
MyFile = Dir(MyFolder & "\*.*")
a = 0
Do While MyFile <> ""
a = a + 1
Cells(a, 1).Value = MyFile
MyFile = Dir
Loop
End Sub
thank you