copy module and past module in new workbook

Hi guys,

I've got a beautifull code that works perfect for sending a workbook. Now I want to copy a module from my source book to the destination workbook but it doesn't succeed : ( the module that I want to copy is module 10 (sub check_files). Please help. Below the code:

Please Login or Register  to view this content.

Originally Posted by xladept

Hi flunzy,

Is the destination workbook macro-enabled??

Hi XL adept,

The destination workbook is macro-enabled. I've made a workaround that partly does the trick. I've saved the module on a fixed location and added a macro that imports the module. This succeeds but when the module is imported and linked to the button, it states that the macro is only available in original sheet : ( Below you find the codes

The send option:

Please Login or Register  to view this content.

and this is the module that needs to be imported:

Please Login or Register  to view this content.