Import a macro (module) into the active Excel workbook

[MrHockey]

Hello everyone and thank you for reading my post. I am having trouble importing a module (VBA macro). I have two excel workbooks open one is host, the other is export. The export workbook is a copy of a worksheet originating from the host workbook. The first part of my code works fine:

Please Login or Register  to view this content.

then I make the export workbook active and try to import the module like this:

Please Login or Register  to view this content.

and it imports into the Host instead of NWBN. I suppose activating a workbook is not the same as activating the VBProject, but that's just a guess. In short, the import works but imports into the wrong workbook. Can anyone suggest how to import into NWBN.

Many thanks to all,
Roger

[rylo]

Hi

I got it to import into the required workbook using the form

Please Login or Register  to view this content.

but I'm not sure that it will be going into the specific module that you want.

rylo