Hi,
I have an Excel file (let's call it MyFile.xls) that references to another
one called library.xls. When I open MyFile.xls it opens library.xls (as
expected...).
The problem appears when I close MyFile.xls. After I close it (either saving
it or not), I can still see it listed in the "Project Explorer" window in
VBA. If I check the references for library.xls, one of the listed items is:
UNSAVED: VBAProject, although it is not selected
.. If I open MyFile again and then close it, I find two similar items
UNSAVED: VBAProject in the References form and two instances of this file in
the "Project Explorer" window (and so on as the times I open and close the
file).
If I try to close the file library.xls I get the Excel message:
"The workbook is currently referenced by another workbook and cannot be
closed"
I hope I was clear enough.
Thanks in advance.