Solved

Move from Office 2003 to 2007 - Excel seems to have old add-in that we can't remove

Posted on 2010-08-13
5
784 Views
Last Modified: 2012-08-13
Hi.  We went from office 2003 to 2007 (only one PC so far to do testing).  Now when we open any excel sheets, even a new one, we get an error "Compile error: Can't find project or library" and the Excel VBA opens and is in an old add-in (ExcelToGM6x.xla) for software (Goldmine) we don't use any more.  

I don't know why this vb screen keeps coming up but it gets stuck on a line with UCASE highlighted.  It's very strange.  I tried running diagnostics on Office but that didn't help.  Also, I went into Add-ins to try to remove that add-in but it's not there.  

Does anyone have any suggestions?

Thanks,
Alexis
0
Comment
Question by:alexisbr
  • 4
5 Comments
 
LVL 15

Expert Comment

by:JBond2010
ID: 33430177
Most likely, the application has lost the reference to an object or type library resulting in the above error when using Barcode Macros & Native VBA Functions. The problem may be resolved as follows:

Open the database or application.
Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
On the Tools menu, click References.
Clear the check box for the type library or object library marked as "Missing:"
An alternative to removing the reference is to restore the referenced file to the path specified in the References dialog box. If the referenced file is in a new location, clear the "Missing:" reference and create a new reference to the file in its new location.

0
 

Author Comment

by:alexisbr
ID: 33430740
JBond2010, Thanks for your response.  I should have said that I had already checked References before I created this post.  There were no lines marked as Missing. Also, this is an old add-in and we don't need it any more.  I'm not sure why it is giving a problem in Excel 2007 when this didn't happen in Excel 2003.  

Any other ideas?
Thanks,
Alexis
0
 

Author Comment

by:alexisbr
ID: 33432072
I took a screenshot of the error I get when opening any Excel sheet in 2007 and have attached it.  I don't understand why this add-in keeps running even though it's not being used and the add-in has nothing to do with any of the sheets I am opening.  I checked the references again and a Goldmine reference was checked.  There were no missing references.  I unchecked the Goldmine reference but that didn't work - I got an error about the DLL not being present.  We got a new server last week. Is it possible that Excel 2007 somehow "remembers" the old add-in from Excel 2003 but now the add-in no longer exists on the server so it can't find it but also can't remove it?  Does this make any sense?  I''m also attaching a screenshot of the References screen.

Alexis
excel-2007-error.png
references.png
0
 

Accepted Solution

by:
alexisbr earned 0 total points
ID: 33437645
I figured out the problem.  I just had to re-register the DLL behind the reference.  A new server was installed last week and was not set up using the same server name.  Apparently Office 2007 has a problem with finding the DLL associated with the Goldmine reference although Office 2003 is still okay with it.  

I went to Start/Run (this is in XP Professional) and registered the DLL using the following line:
\\Newserver\shared\goldmine\gmw6.exe /regserver

I've also attached an image showing what I did.  I will accept my own answer in case someone else has this same problem in the future.

Alexis
reregister-GM.jpg
0
 

Author Comment

by:alexisbr
ID: 33486314
I discovered that this problem had nothing to do with Office 2003 or 2007.  The problem in Excel was caused by the new server being named differently from the old server so the registered exe file could not be found.  Our user had this problem in Office 2003 and 2007.   Once I registered the exe file in the location on the new server using the new server name, it all worked fine.  I wanted to clarify this for future readers of this post.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now