Opening Notepad from Code

[Guest]

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

 

[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

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.

 

[Tom Ogilvy]

Some sample code at Chip Pearson's site:

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

--
Regards,
Tom Ogilvy

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.

 

[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

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