VBA: Save Textbox Value As Text File

[Faiek]

Hi,
I'd like to have a button in a userform where the user clicks and It prompts them with the save as dialog. After choosing the location and name it creates a text file and fills it with the data from a textbox. Can Anyone help me with this?

Thanks

 

[stapuff]

On your button click event add



mytxt = textbox1 'whatever text box your text is in
Open "c:\your file path.txt" For Append As #1 ' change the path to reflect your path
Print #1, mytxt
Close #1

stapuff

 

[exreporter]

This is an old discussion and I have a question.
Instead of this specified path, is it possible to save the text to a default location of the original file?