Opening Notepad from Code

S

Stan

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
 
T

Tom Ogilvy

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 said:
Hi All,

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

Tom Ogilvy

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 said:
Thanks Tom,


Currently in order to process our orders, we copy text from Siebel, and
Click to expand...
dump it onto Notepad for reference.
What I'm trying to do is have all the info (at the click of a button) fill
Click to expand...
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
Click to expand...
reference (ie with 2 windows open).
 
Top