Solved

Each time excel opens, I get VB error

Posted on 2011-09-13
9
1,979 Views
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?

Thanks
D
0
Comment
Question by:daiwhyte
9 Comments
 
LVL 16

Expert Comment

by:carsRST
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.  
dlgComReferencesExcel.png
0
 

Author Comment

by:daiwhyte
ID: 36529289
Wrere do I the references to?
0
 

Author Comment

by:daiwhyte
ID: 36529291
Found references
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 12

Expert Comment

by:GMGenius
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
0
 

Author Comment

by:daiwhyte
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?
0
 

Author Comment

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

Expert Comment

by:GMGenius
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:" ?
0
 
LVL 11

Accepted Solution

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

Try uninstall/reinstall the link?

Try turning off macro security in Excel?
0
 

Author Closing Comment

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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 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