open notepad and paste text without saving to file

[Jesper]

I know I can export data to a text file.
Is it also possible to open up notepad and paste a chunk of text into it?

Jesper

 

[Douglas J. Steele]

Not reliably. Notepad doesn't support automation. While you might be able to
cobble together code that automates keystrokes, if the user clicks anywhere
while the code is running, it won't work properly.

 

[John Nurick]

You can export to a text file and then use something like

lngRetVal = Shell("notepad.exe """ & strFileSpec & """")

to open it in Notepad.

 

[Jesper]

Not reliably. Notepad doesn't support automation. While you might be able

to cobble together code that automates keystrokes, if the user clicks
anywhere while the code is running, it won't work properly.

Thanks both of you.