Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
This is an odd behavior I noticed in one of my client's machines: He has fileA.xls and fileB.xls opened in Excel. Both files are based on the same template so they have the same Macros (that in turn point to a COM DLL). In the VBA Editor I can see the macros associated to each one of the files. When I close one of the files, Excel closes it but when I take a look in the VBA Editor it turns out that Excel doesn't unload the associated macros immediately. After a while it finally does it but in this small period of time is causing some conflicts with the workbook that continues to be opened. Has anybody come accross this odd behavior?, how can I isolate one Excel file from another (including isolating the macros and DLLs associated)? Thanks, MV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Force Macro | Excel Discussion (Misc queries) | |||
force users to enable macro so sheet cannot be printed | Excel Discussion (Misc queries) | |||
Auto force a macro | Excel Discussion (Misc queries) | |||
Force read-only in auto_open macro | Excel Discussion (Misc queries) | |||
How do I force an Excel macro to ask me which file and directory? | Excel Discussion (Misc queries) |