Shell open Notepad and write text

[vqthomf]

Hi is it possible to open Notepad and write text and let the user print or
/and save the file, I tried using the SendKeys strText, True after opening
Notepad but this wont work. Any help would much appreciated.
Charles

 

[joel]

It seems you are having problems puting text into Notepad. Why no
write the data as a text file then open the text file with note pad an
print.


ID = shell("C:\windows\notepad.exe c:\myfile.txt"

 

[Dave Peterson]

If your code knows what to write, you could create/append the text file in code.

Look at "Print # Statement" in VBA's help.