I'm saving and opening Files using FSO. When the File path is 'hard coded' thus:
Set fsoStream = fso.CreateTextFile("c:\ApplicationArchive\MyApplicationSettings.STP", True)
everything works fabulously.
However, what I want to be able to do is to get the path and filename from the user via a 'Save File As' Dialog box, and use that in the fsoStream expression to create the file.
I've tried the following but it doesn't work:
Text1.Text= "c:\ApplicationArchive\MyApplicationSettings.STP" 'captured from user via Dialog box
Dim FileString as String
FileString = Chr(34) & Text1.Text & Chr(34)
Set fsoStream = fso.CreateTextFile(FileString, True)
What am I doing wrong? How can I use the returned path and filename in a variable to create the file using FSO?