Exported Macro fails

Exported Macro fails

Post by VG9ueWEgTS » Thu, 13 Nov 2003 11:11:13

VBA project comprised of 2 modules and 1 form and created in an XL startup file works fine on my machine. Project then exported to another workbook - still works fine on my machine. Now I've emailed my workbook (including imported VBA project - which still works fine for me) to 3 other users. Every user getting same error message. "System error . . . catastrophic failure". User hits "ok" here and another message box pops up saying "out of memory".

Can some one tell me what I need to do to get this macro working on other's machines. Don't know if it makes a difference, but macro includes connecting to databases using EssVConnect command for Hyperion Essbase Add-in. Other users have the same add-in

Any help would be greatly appreciated

Thank you in Advance