| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export Import Modules File Name error | Excel Programming | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
| Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming | |||
| How do I import text file, analyze data, export results, open next file | Excel Programming | |||
| Export / Import to / from Text file | Excel Programming | |||
Linear Mode
