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

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

Using Excel 2003 SP2.

Thanks
MakeLei

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

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").E xport "usef.frm"
'second workbook to receive userform
Workbooks("Book.xls").VBProject.VBComponents.Impor t InitialPath & "usef.frm"
End Sub

HTH
Cordially
Pascal


"Makelei" a écrit dans le message de
news: ...
Hi,
How can I - using VBA - export Userform to another file - or just copy...

Using Excel 2003 SP2.

Thanks
MakeLei