View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mbt6 Mbt6 is offline
external usenet poster
 
Posts: 7
Default Shell command to post to notepad

I want to paste some information to note pad from excel

in vba I do something like

Range("c2").Select
Range(Selection, Selection.End(xlDown)).Copy
Shell("notepad.exe")


I need something in the Shell command to make the notepad window active, and
be able to paste to it. Any ideas?

--thanks --mike