Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

UNSAVED: VBA Project

1 view
Skip to first unread message

Fabian Grodek

unread,
Dec 23, 2004, 1:53:18 AM12/23/04
to
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, with its check box unselected.
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".
Why are the files I already closed still appearing in the Project browser
window?
I hope I was clear enough.
Thanks in advance.

Frank Kabel

unread,
Dec 23, 2004, 1:27:12 PM12/23/04
to
Hi
just a wild guess: Do you have the Google Desktop Search tool installed?. If
yes see:
http://www.dicks-blog.com/archives/2004/12/11/google-desktop/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany

Fabian Grodek

unread,
Dec 27, 2004, 12:14:33 PM12/27/04
to
Hello Frank,
That was a very good wild guess !!! Although my add-ins are not password
protected, my problem was indeed solved by uninstalling GDS.
Many thanks!.
Regards,
Fabian
0 new messages