View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Startup Notepad from Excel???

How about if I use those old school DOS "named pipe" or
output filters in the shell() command?? For example,
something like:

shell("string" notepad.exe) ' ?????

Hmmm, I'm probably barking up the wrong tree here, haha!

"Peter T" <peter_t@discussions wrote in message
...
It is possible without creating the file but it's convoluted API stuff.
Don't bother, write to file as RBS suggests. If you Shell to Notepad you
could go on to Kill (ie delete) the file even with the file still open in
Notepad.

BTW, you don't have to use CurDir, could be to any folder to which you
have access, but note in newer Windows write access is much more limited.
Application.DefaultFilePath might be a better folder to start in. Also you
could name the file (almost) anything you want, doesn't need .txt

Regards,
Peter T