Open Notepad and Put Data

[Faiek]

Hi,
I would like to make a button that opens the notepad.exe and then pastes data from different textboxes on a userform on that open notepad window. Can anybody help with this?

Thanks

 

[wigi]

For instance, use this to write data to the file C:\test.txt:

    Open "C:\test.txt" For Output As #1
    Print #1, Me.TextBox1.Text
    Close #1

The textbox is called TextBox1 in this example.

 

[AlphaFrog]

Do you have a need to use specifically Notepad.exe or are you looking for a way to save your textbox.text to a text file?

 

[Faiek]

Do you have a need to use specifically Notepad.exe or are you looking for a way to save your textbox.text to a text file?

I'm looking for a way to save it to a textfile. Wigi's solution is almost correct, But in the code I would like to create a textfile and let the user name it then save it.

 

[wigi]

The Inputbox function is often used in other threads.

    Open Application.InputBox("please specify file and path", Type:=2) For Output As #1
    Print #1, Me.TextBox1.Text
    Close #1

 

[Faiek]

The Inputbox function is often used in other threads.

    Open Application.InputBox("please specify file and path", Type:=2) For Output As #1
    Print #1, Me.TextBox1.Text
    Close #1

Can you please explain this? I can't seem to get it working.

 

[wigi]

What happens when you execute it?

 

[Faiek]

It opens the input window, but when I put in the path and name it doesn't create the file? Does this code actually include the file creation part because from what I see it doesn't.

 

[wigi]

Yes, it does. What is the path and filename you type into the box/input window?

 

[Faiek]

Oh My Mistake, I got it working now. Thanks So much. One other question is there a way to make the Save as dialog appear instead to make it more convenient for the end-user?