I would like a user of my program to choose the destination folder where a .txt file will be saved.
I have code below which allows the chooser to browse through folders and choose a file:
I want the user to browse folders and subfolders like they can with the above code. However the user will select a file path not a particular file. In the case of the code above, the text of Text Box txt2 would be set to the file path (i.e. "C:\Documents and Settings\Administrator\Desktop")
Dim f1 As Variant, s1 As Variant
s1 = "#1: Choose the .txt file which contains montly data for the stock price."
f1 = Application _
.GetOpenFilename("TextFiles(*.txt),*.txt", , s1)
txt2.Text = f1