My VB modules seem to remain in memory, even after the workbook containing
them has been closed. Open workbooks which had been referenced in VB by a
closed workbook cannot be closed, without shutting down Excel itself. Often
this leads to an error. Any suggestions, please.

Ricardo wrote:
My VB modules seem to remain in memory, even after the workbook
containing
them has been closed. Open workbooks which had been referenced in VB
by a
closed workbook cannot be closed, without shutting down Excel itself.
Often
this leads to an error. Any suggestions, please.




Don't Write Modul in Personal.xls
instead use one File excel to keep all macros (for e.g macroserver).
and then other files you can use command 'application.run' pointting to
macroserver'

maybe this can help.

This can be caused by Google Desktop/Search being installed

http://www.dicks-blog.com/archives/2...oogle-desktop/

--
Regards,
Tom Ogilvy

"Ricardo" wrote in message
...
My VB modules seem to remain in memory, even after the workbook containing
them has been closed. Open workbooks which had been referenced in VB by a
closed workbook cannot be closed, without shutting down Excel itself.
Often
this leads to an error. Any suggestions, please.