Add-in Already Open

[Erin Searfoss]

A user has a macro stored in his start up folder. It's been working fine for
years until recently he started receiving an error message on start up which
says "A document with the name 'Reports.xla' is already open. You cannot
open two documents..." We can't find any other instance of this file on his
computer. If we uncheck the add-in in the Tools, Add-Ins dialog box and
close Excel it opens fine, but the next time Excel is closed and opened the
warning is back.

We're using Excel 2003 SP3. Has anybody experienced a similar problem or
have any ideas what might be causing it? Any suggestions would be
appreciated.

Thanks.

Erin

 

[Erin Searfoss]

Nevermind. I found the problem. Somehow Excel was picking up an old copy of
the file the user had in his Outlook temp folder. I imagine it never came up
on a search because that folder is hidden - a pet peeve of mine already.

FYI to anyone searching this post later, I found the offending copy by
deleting the proper copy from the startup file, seeing that the add-in was
still installed, selecting the add-in file in VBA, and typing in the
Immediate Window ?ThisWorkbook.Path. I copied the result into Windows
Explorer and deleted the offending copy from that folder. I then saved a
good copy back to the startup folder, and when I opened Excel it properly
installed.