Copying Userform with Controls OR complete application.

[Guest]

I have written an application that automates an excel based pricelist. It
includes:
- A quoteform and orderform that are sheets added to the basic pricelist
workbook
- code that is Located in the code module associated with each worksheet.
- 5 userforms

In order to complete the project I need to be able to copy the code and
userforms to a new pricelist spreadsheet when released:

1. The easiest way seems to be if I is just to copy the code modules using
an export/import procedure. THis has partially worked except
a. the controls on the userforms are not getting copied
b. I am getting an error whenever the module type is type 100, a document
Any ideas about this?

2. Is there a better way to copy an application? Like an add-in or something
else?
The only reason I am using the code modules behind each worksheet is to
take advantage of the doubleclick event from the worksheet. Is there a way
to relocate the doubleclick events from several modules to separate module,
instead of keeping it in the individual spreadsheets?

2a. Can I bundle the Userforms and the "universal" code module of question 2
into a single add-in?

Thanks,

 

[Guest]

You can copy the file to a new folder then rename the file to the new
official name.

To copy a file or folder
Open Windows Explorer Start>Programs>Accessories>Windows Explorer [Click]
Create a new folder and name it.
Click the file or folder you want to copy. Under the Edit menu, select Copy
to Folder and click. Select the new folder you want to copy to and click.

 

[Guest]

I dont think I expressed myself properly. The desire is to copy the code
modules to a workbook which doesnt have the code in it.

You can copy the file to a new folder then rename the file to the new
official name.

To copy a file or folder
Open Windows Explorer Start>Programs>Accessories>Windows Explorer [Click]
Create a new folder and name it.
Click the file or folder you want to copy. Under the Edit menu, select Copy
to Folder and click. Select the new folder you want to copy to and click.

I have written an application that automates an excel based pricelist. It
includes:
- A quoteform and orderform that are sheets added to the basic pricelist
workbook
- code that is Located in the code module associated with each worksheet.
- 5 userforms

In order to complete the project I need to be able to copy the code and
userforms to a new pricelist spreadsheet when released:

1. The easiest way seems to be if I is just to copy the code modules using
an export/import procedure. THis has partially worked except
a. the controls on the userforms are not getting copied
b. I am getting an error whenever the module type is type 100, a document
Any ideas about this?

2. Is there a better way to copy an application? Like an add-in or something
else?
The only reason I am using the code modules behind each worksheet is to
take advantage of the doubleclick event from the worksheet. Is there a way
to relocate the doubleclick events from several modules to separate module,
instead of keeping it in the individual spreadsheets?

2a. Can I bundle the Userforms and the "universal" code module of question 2
into a single add-in?

Thanks,