Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have an Excel Workbook that has Macros (both at Worksheet and module levels) that in turn delegates most of the business logic to a VB6 COM component. OK, the problem is that when I have two different instances of this workbook opened in the same PC, it seems that they are conflicting with one another (I'm getting a lot of ActiveV instantiation problems). I'm wondering what's the best way to 'isolate' this 2 Worbooks, should I move all my module-level code to Worksheets? Any ideas? Thanks, MV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros in shared workbooks | Excel Discussion (Misc queries) | |||
Macros common to several workbooks | Excel Worksheet Functions | |||
Cascading macros to new workbooks | Excel Worksheet Functions | |||
Making Macros Available in All Workbooks | Excel Worksheet Functions | |||
Using VBA macros in all workbooks | Excel Programming |