ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Newbie VBE scripting question (https://www.excelbanter.com/excel-programming/319325-newbie-vbe-scripting-question.html)

Jeff

Newbie VBE scripting question
 
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?



Jim Rech

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?
|
|




All times are GMT +1. The time now is 02:18 PM.

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