ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shell open Notepad and write text (https://www.excelbanter.com/excel-programming/437398-shell-open-notepad-write-text.html)

vqthomf

Shell open Notepad and write text
 
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[_347_]

Shell open Notepad and write text
 

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


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


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=162269

Microsoft Office Help



All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com