Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default How to force Workbook's macro unloading?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Force Macro BNT1 via OfficeKB.com Excel Discussion (Misc queries) 0 June 18th 09 11:01 AM
force users to enable macro so sheet cannot be printed Zambian Excel Discussion (Misc queries) 3 December 10th 08 07:36 PM
Auto force a macro Jase Excel Discussion (Misc queries) 3 October 27th 08 03:12 PM
Force read-only in auto_open macro hhalle Excel Discussion (Misc queries) 0 August 20th 06 10:44 AM
How do I force an Excel macro to ask me which file and directory? Ramius Excel Discussion (Misc queries) 4 January 14th 05 03:26 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"