Export module

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

How do I export one specified module called "1Year" to C:\?

I have use the pearson website and I am still having
problems.


Thanks
Todd Huttenstine
 
Oh I got it. Used the following code:

WkBkName = ComboBox1.Value
CompName = ComboBox2.Value
With Workbooks(WkBkName)
FName = "C:\Test\" & CompName & ".txt"
.VBProject.VBComponents(CompName).Export FName
End With
End If
 
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

Bloodhound.ExcelMacro 6
Trim "\" Value 7
Import and Export 3
Renaming a standard module 5
Class Module 2
Empty Modules 2
OnAction to show a userform 1
Export Code Module 5

Back
Top