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]

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?

That's a different question, hence start a new topic for it.

But first, use the Search function of the forum, because such questions are asked over and over again.

 

[Faiek]

That's a different question, hence start a new topic for it.

But first, use the Search function of the forum, because such questions are asked over and over again.

Okay Thanks For Everything.

 

[Ruddles]

Try this:-

  Dim sFileName As String
 
  sFileName = Application.GetSaveAsFilename(FileFilter:="Text files (*.txt), *.txt")
  If sFileName = "False" Then Exit Sub

That only gets the file name and stores it in sFilename - it doesn't actually do any saving.

 

[Faiek]

Thanks For the reply.