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