Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 804
  • Last Modified:

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

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
alexisbr
Asked:
alexisbr
  • 4
1 Solution
 
JBond2010Commented:
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
 
alexisbrAuthor Commented:
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
 
alexisbrAuthor Commented:
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
 
alexisbrAuthor Commented:
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
 
alexisbrAuthor Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now