E excelent Board Regular Joined Sep 7, 2002 Messages 105 Sep 14, 2002 #1 Hi group Is it possible to have a group of modules ( in a workbook) combined into 1 module so i only have to import or export 1 module. thanks. mike.
Hi group Is it possible to have a group of modules ( in a workbook) combined into 1 module so i only have to import or export 1 module. thanks. mike.
Joe Was MrExcel MVP Joined Feb 19, 2002 Messages 7,539 Sep 14, 2002 #2 Yes, just copy paste each module into any one. Then Right click the old module and say Delete, click no so you don't waist time Exporting, you don't need to. Make sure you delete the old modules. JSW
Yes, just copy paste each module into any one. Then Right click the old module and say Delete, click no so you don't waist time Exporting, you don't need to. Make sure you delete the old modules. JSW
E excelent Board Regular Joined Sep 7, 2002 Messages 105 Sep 14, 2002 #3 Thanks Joe. That did the trick. mike.
S stevebausch Well-known Member Joined May 11, 2002 Messages 810 Sep 14, 2002 #4 If it worked, fine. Just make sure you are consolidating a spare copy, not the only copy. When you consolidate modules, you increase the scope of variables; and unintended results may occur.
If it worked, fine. Just make sure you are consolidating a spare copy, not the only copy. When you consolidate modules, you increase the scope of variables; and unintended results may occur.