I am testing something because I am going to be programming the VBE behind
several workbooks. I was testing the following and I got the error
called..Compile Error: Argument not optional. Is there a reason why? Then
it focused on the .Export function.

Sub CopyOneModule()

Dim FName As String

With Workbooks("sirNAsequences7")
FName = .Path & "\code.txt"
.VBProject.VBComponents("Module1").Export
FName
End With
Workbooks("Changemodulecode").VBProject.VBComponen ts.Import
FName

End Sub