Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 252
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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   Report Post  
Posted to microsoft.public.excel.programming
MaC MaC is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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   Report Post  
Posted to microsoft.public.excel.programming
LT LT is offline
external usenet poster
 
Posts: 25
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export as XML for an Excel Order form document Diane Excel Discussion (Misc queries) 1 October 21st 08 04:44 PM
Export data from excel to IE form Shuvro Basu Excel Programming 0 May 4th 06 07:58 AM
user form export ziociccio Excel Programming 1 August 10th 05 01:40 PM
export form?? FSt1 Excel Programming 4 August 19th 04 05:01 PM
Export a form via code? [email protected] Excel Programming 4 January 26th 04 05:22 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"