Export and Import Userform from Excel-file to another Excel-file

[Makelei]

Hi,
How can I - using VBA - export Userform to another file - or just copy...

Using Excel 2003 SP2.

Thanks
MakeLei

 

[papou]

Hello MakeLei

Tested on Excel 2003 SP2 WinXpPro SP2:
(Make sure second file is open and amend accordingly)

Sub ExportAndImport()
Dim InitialPath$
InitialPath = ThisWorkbook.Path & Application.PathSeparator
ThisWorkbook.VBProject.VBComponents("Userform1").Export "usef.frm"
'second workbook to receive userform
Workbooks("Book.xls").VBProject.VBComponents.Import InitialPath & "usef.frm"
End Sub

HTH
Cordially
Pascal

 

[Makelei]

Hi papou,
Thanks, this works OK when Formfile is in hard drive, how could I use one
that is in network server?

BR
MakeLei