Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export a form
Hi all,
I have to export a form from one workbook into anthor workbook. Could you tell me how to do it Clara -- thank you so much for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
export a form
Open both workbooks and just drag and drop the form module in the VBE.
RBS "clara" wrote in message ... Hi all, I have to export a form from one workbook into anthor workbook. Could you tell me how to do it Clara -- thank you so much for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
export a form
Go to VBA editor. Select form you want to copy. Click menu File, Export.
Then browse disk location and save a form file (e.g. UserForm1.frm). Then open destination workbook and from VBA editor select menu File and Import. Browse for saved form file and click Open. New form should be imported and to appear in VBA editor. HTH Mariusz Użytkownik "clara" napisał w wiadomo¶ci ... Hi all, I have to export a form from one workbook into anthor workbook. Could you tell me how to do it Clara -- thank you so much for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
export a form
Using code:
http://www.cpearson.com/excel/vbe.htm Otherwise, in the project explore, right click on the entry for that form and choose export (give it a name and a memorable location) go to the workbook to receive the form, right click on the workbook name and select Import file, then select your form. -- Regards, Tom Ogilvy "clara" wrote: Hi all, I have to export a form from one workbook into anthor workbook. Could you tell me how to do it Clara -- thank you so much for your help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
export a form
On May 4, 3:35 pm, clara wrote:
Hi all, I have to export a form from one workbook into anthor workbook. Could you tell me how to do it Clara -- thank you so much for your help Hi Clara. Again, if your looking for code to do this automatically, maybe someone here knows this but for now, I can help you do this manually. From the workbook that contains the form you want exported, hit together your alt+F11 key that will bring up the VBA editor. From there, select the form you want to export from the list on your left. It's setup like MS Explorer style so you may need to click a few + signs or so (especially under FORMS) to see the form you want to export. When you find it, select it, then right click it and choose EXPORT. Save it to a location you want then when you want to IMPORT the form, go back to your VBA editor, choose File and then IMPORT. Hope that helps! -LT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export as XML for an Excel Order form document | Excel Discussion (Misc queries) | |||
Export data from excel to IE form | Excel Programming | |||
user form export | Excel Programming | |||
export form?? | Excel Programming | |||
Export a form via code? | Excel Programming |