Macro to export and import a module and assigning different macro automatically

I have had a go at this but I have clearly not got it right.

The code I have used is:

Please Login or Register  to view this content.

I would like the sheets Purchase order and Continuation sheet to be copied and saved which the Copy_Save Macr does however when this does this I want module 2 in my VBE to go with the new sheet.

I'm sure it can work but i have not done it right .

Any help gratefully recieved.

Thanks

Hi Libster78
I use this
where CopyAMouldle( wkb From, wkbTo , "Module2")

Please Login or Register  to view this content.

you need to set the variables and run call the sub

Please Login or Register  to view this content.

eg

Please Login or Register  to view this content.

Still persevering with your little project I see.

Pike's suggestion should work fine but a more basic solution would be:

Please Login or Register  to view this content.

You could just call that after you have copied the sheets to the new workbook.

Dom

The code I posted should get round that as it transfers the module from the workbook that you are running the code (ThisWorkbook) from and the ActiveWorkbook should always be the one that is created when the sheets are copied to the new workbook.

Edit: not tested but you could probably use Pike's function like this to get round that as well:

Please Login or Register  to view this content.

Dom

You can assign the macro to run to a button like this:

Please Login or Register  to view this content.

Dom

I am not sure but it looks like a try to export/import a Data Module (that is the workbook's and the worksheets own code) which is impossible. The only Code Modules which can be ex- and imported are Standard Code Module (.bas), Class Module (.cls) and UserForm (.frm, .frx). The only way to still ex-/import code in Data Modules is to move the code into a Standard Module and just leave the call to it on the original place. So for example in a Standard Module called modWrkbk:

Please Login or Register  to view this content.

and in the Workbook itself just leave:

Please Login or Register  to view this content.

The same with code in a Worksheet which may be moved e.g. into a Standard Module called modWshxxx:

Please Login or Register  to view this content.

and in the Worksheet just leave:

Please Login or Register  to view this content.

This way Data Modules will no longer contain any code but the call to another Standard Module's public procedure. Data Modules in the end contain nothing but the event procedures ..._Open, ..._Change, ...._BeforeDoubleClick, etc.

Last but not least I recommend to provide each Worksheet with a proper object name (e.g. wshXxxx) and use this throughout the project. This way you not only become independent from the name of the tab which can then be anything meaningfull for the user and even renamed when applicable, but also end up with a much clearer code because instead of

Please Login or Register  to view this content.

You will say

Please Login or Register  to view this content.