Newbie VBE scripting question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
I don't believe Wordpad supports automation. How about just exporting the
module's text?:

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


--
Jim Rech
Excel MVP
|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?
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't see Modules and Worksheets in VBE 5
Securing codes by corrupting the file (Leo Asked) 3
Technique for switching to the VBE 16
Personal Macro Book and VBE showing 3
Differente .xls files generated when VBE window closed vs open 3
Return to excel from vbe 4
Closing Outlook VBE from Excel 1
VBE and Arranging Windows 2

Back
Top