Export module

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
 
T

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
 
Top