export a form

[Guest]

Hi all,

I have to export a form from one workbook into anthor workbook. Could you
tell me how to do it


Clara

 

[RB Smissaert]

Open both workbooks and just drag and drop the form module in the VBE.

RBS

 

[MaC]

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

 

[Guest]

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.

 

[LT]

Hi all,

I have to export a form from one workbook into anthor workbook. Could you
tell me how to do it

Clara

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