View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Newbie VBE scripting question

I don't believe Wordpad supports automation. How about just exporting the
module's text?:

ThisWorkbook.VBProject.VBComponents("Module1").Exp ort _
"c:\ModText.txt"


--
Jim Rech
Excel MVP
"jeff" wrote in message
...
|I would like to script the VBE to select the text in a module and open up
| Wordpad, paste the text and save it.
|
| Can I do this?
|
|