I have written this macro below. I get an error on the Workbooks(ThisWorkkBook).VBProject.VBComponents("Module1").Export strTempFile.
How do I define this?
Sub CopyModule()
Dim wb1 As Workbook
Dim ws1 As Worksheet
Dim Path As String
Dim FName As String
Dim wb2 As Workbook...