Hi
I'm working on a program that processes files in a choosen folder. I want the user to select the folder they want to process by browsing in the folder tree. How do I do this?
For lack of a better idea, I now use a workaround, namely selecting a file by GetOpenFilename, then retrieving the path from the filename.
[vba]Public MainFolder as String
Sub SelectFolder()
MainFolder = Application.GetOpenFilename(, , , , False)
MainFolder = Left(MainFolder, InStrRev(MainFolder, "\"))
End Sub[/vba] Anyone knows of a better way?
Thanks,
Jimmy