open notepad and paste text without saving to file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jesper - 09 Aug 2005 00:33 GMT

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

Reply to this Message

Douglas J. Steele - 09 Aug 2005 00:48 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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

Reply to this Message

Jesper - 09 Aug 2005 18:54 GMT

> 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.

Reply to this Message

John Nurick - 09 Aug 2005 07:57 GMT

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

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

to open it in Notepad.

>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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message