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


-----Original Message-----
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


.