Hi All,

At the click of a button in an Excel/VBA program I have, I want to open Notepad, paste what is in the memory into it and then swtch back to excel as the 'Active' application.

Could anyone help me with this - any would be greatly appreciated?

Cheers in advance,

Stan

If you want to write a text file, using notepad is not the best way to do
it. You can write a text file directly from excel.

--
Regards,
Tom Ogilvy

"Stan" wrote in message
...
Hi All,

At the click of a button in an Excel/VBA program I have, I want to open
Notepad, paste what is in the memory into it and then swtch back to excel as
the 'Active' application.

Could anyone help me with this - any would be greatly appreciated?

Cheers in advance,

Stan

Some sample code at Chip Pearson's site:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy

"Stan" wrote in message
...
Hi All,

At the click of a button in an Excel/VBA program I have, I want to open
Notepad, paste what is in the memory into it and then swtch back to excel as
the 'Active' application.

Could anyone help me with this - any would be greatly appreciated?

Cheers in advance,

Stan

If you have text in the clipboard:

Sub Tester3()
Shell "Notepad.exe", 1
DoEvents
Application.SendKeys "^v", True
AppActivate Application.Caption

End Sub

--
Regards,
Tom Ogilvy

"Stan" wrote in message
...
Thanks Tom,


Currently in order to process our orders, we copy text from Siebel, and
dump it onto Notepad for reference.
What I'm trying to do is have all the info (at the click of a button) fill
in a forma dn in turn a spreadsheet. I have got the program to do this, but
whilst I'm testing what it does, I'd like it to paste the info onto Notepad
as well.

The info that gets pasted isn't to be used for anything other than
reference (ie with 2 windows open).

What would be the best way just to open and dump this info?

Thanks again Tom

Stan

"Tom Ogilvy" wrote:

Some sample code at Chip Pearson's site:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy

"Stan" wrote in message
...
Hi All,

At the click of a button in an Excel/VBA program I have, I want to
open
Notepad, paste what is in the memory into it and then swtch back to
excel as
the 'Active' application.

Could anyone help me with this - any would be greatly appreciated?

Cheers in advance,

Stan