Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conversion from notepad to excel | Excel Discussion (Misc queries) | |||
Notepad to excel | Excel Discussion (Misc queries) | |||
Word Or Notepad From Excel | Excel Programming | |||
notepad to excel | New Users to Excel | |||
notepad in excel | Excel Programming |