Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Each time excel opens, I get VB error

Posted on 2011-09-13
Medium Priority
Last Modified: 2013-11-15
Hi Guys,

Each time I open Excel, the VB Editor associated with either Excel 2003 or 2010 opens up and displays the following error.

Microsoft Visual Basic
Compile error:

Object library invalid or contains references to object definitions that could not be found
OK   Help  

The VB project name is ExcelToGM6x.xla so Im assuming its something to do wtih the the Goldmine addin for office.

Any ideas why this is happening?

Question by:daiwhyte
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 16

Expert Comment

ID: 36529250
Check your references within the VB editor.  Tools->References
See image.  
What you'll probably notice is one of the items checked will say that the reference is missing.  What ever it is you'll either need to install or find where it's located.  

Author Comment

ID: 36529289
Wrere do I the references to?

Author Comment

ID: 36529291
Found references
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 12

Expert Comment

ID: 36529293
Open Excel
Go to help>about>disabled items, and re-enable the GoldMine addin.

In 2010 disabled items are accessed from the big round button excel options > addins

Author Comment

ID: 36529303
This is the line which is highlighted when the VB Editor loads.

Public Function GMDataExecute(ByVal sXMLIn As String, Optional ByRef GM As GoldMine.GoldMineData = Nothing) As String

Does that mean anything to you?

Author Comment

ID: 36529329
there is no addin within Excel 2010 to disable and its the same for 2003?
LVL 12

Expert Comment

ID: 36529415
That tells me the goldmine addin is disabled.

when you look at the references as the screen shot shows, is there anything listed "MISSING:" ?
LVL 11

Accepted Solution

stevengraff earned 2000 total points
ID: 36529421
Same behavior for all users?

Try uninstall/reinstall the link?

Try turning off macro security in Excel?

Author Closing Comment

ID: 36708354
Sorry for delay, not been back at the office. Reinstalled GMLink.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

604 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