Copy all text from textbox, open notepad, and automatically paste to new notepad shee

Hello everyone.

I am trying to copy all text, that is already in the textbox, to a new notepad sheet.

Example:

Step 1. Copy all text in Text1 box to clipboard.
Step 2. Open Notepad
Step 3. Paste clipboard to notepad.

All this should be done with one click of a button.

I get as far as copying everything to the clipboard, and it even opens up notepad, but I still have to manually paste (CTRL-V) into notepad.

I would even like it to ask me what name to save it as as well as where to save it at...just like the Save As function in Word or something.

Here is what I have so far.

Private Sub cmdCopytoClipboard_Click()
Dim MyAppID
Clipboard.Clear
Clipboard.SetText Text1.Text
MyAppID = Shell("NOTEPAD.EXE", 1)
AppActivate MyAppID
MyAppID = Clipboard.GetText()


End Sub

You could use the SendKeys command to simulate keyboard usage.

???

How do you mean.

I want to copy the clipboard to notepad.

Do you have an example of what you are referring?

replace MyAppID = Clipboard.GetText() by sendkeys Clipboard.GetText()
if you don't really want to get your text to the clipboard.. just use sendkeys text1.text after your appactivate

Or just:

Private Sub cmdCopytoClipboard_Click()
Dim MyAppID
Clipboard.Clear
Clipboard.SetText Text1.Text
MyAppID = Shell("NOTEPAD.EXE", 1)
AppActivate MyAppID
SendKeys "^V", True ' send CTRL-V
End Sub

Oh...

Well, that works...

Thank you...

Now I am off to figure out how to get it to pull up the Save as window and ask me the filename and directory to where I want to open the file, and then paste the clipboard into it.

Kinda like a Save as window as in word or what not.

You need a CommonDialog to show this type of window.

This is the Microsoft Common Dialog Control, but:

Why bother showing the dialog, if you're going to paste the
filename into it? The whole point is that you let the user choose
the filepath...

Alternatively, if you want a default value in there, just set the
.FileName property of the Common Dialog Control before you
call the ShowSave() method.