Thanks....that did the trick. But do you know how to remove or delete a from.
I can do this with a module but am having issues with a Form. Here is the
syntaxt I use for a module

Set VBComp = Workbooks(RollUpProg).VBProject.VBComponents("User Form1")
ActiveWorkbook.VBProject.VBComponents.Remove VBComp


Leith Ross wrote:
Hello aVBgrad,

The syntax is almost identical to importing or exporting a module. Just
change UserForm1 to the form name you are using. The file name must end
in .frm

'This code must be run from the Workbook the Forms are in to be
exported.
With Workbooks(RollUpProg)
FName = .Path & "\Test Form.frm"
.VBProject.VBComponents("UserForm1").Export FName
End With

'This code must be run from the Workbook that it is in to import the
form.
Workbooks(datafilename).VBProject.VBComponents.Im p ort FName

Sincerely,
Leith Ross


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1