• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2034
  • Last Modified:

Each time excel opens, I get VB error

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?

Thanks
D
0
daiwhyte
Asked:
daiwhyte
1 Solution
 
carsRSTCommented:
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.  
dlgComReferencesExcel.png
0
 
daiwhyteAuthor Commented:
Wrere do I the references to?
0
 
daiwhyteAuthor Commented:
Found references
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
GMGeniusCommented:
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
0
 
daiwhyteAuthor Commented:
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?
0
 
daiwhyteAuthor Commented:
there is no addin within Excel 2010 to disable and its the same for 2003?
0
 
GMGeniusCommented:
That tells me the goldmine addin is disabled.

when you look at the references as the screen shot shows, is there anything listed "MISSING:" ?
0
 
stevengraffCommented:
Same behavior for all users?

Try uninstall/reinstall the link?

Try turning off macro security in Excel?
0
 
daiwhyteAuthor Commented:
Sorry for delay, not been back at the office. Reinstalled GMLink.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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