B
Brett Smith
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.VBComponents.Import
FName
End Sub
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.VBComponents.Import
FName
End Sub