Author Topic: adding in excel 15.0 object library  (Read 12135 times)

0 Members and 1 Guest are viewing this topic.

chrismartz

  • Jr. Member
  • **
  • Posts: 16
adding in excel 15.0 object library
« on: August 01, 2013, 09:54:59 PM »
Hey all

I need to add excel 15.0 object library to visio 2010 but I cannot find either the library or how to do so. Can anyone help?

Thanks,

Chris

Jumpy

  • Hero Member
  • *****
  • Posts: 1061
Re: adding in excel 15.0 object library
« Reply #1 on: August 02, 2013, 12:55:46 AM »
excel 15.0 object library: Is that Excel 2013?

Because you have Visio 2010 I'm bold enough to ask: Do you have Excel 2013 installed?

chrismartz

  • Jr. Member
  • **
  • Posts: 16
Re: adding in excel 15.0 object library
« Reply #2 on: August 02, 2013, 03:02:51 AM »
No Excel 2010.


JohnGoldsmith

  • Sr. Member
  • ****
  • Posts: 357
    • John Goldsmith's visLog
Re: adding in excel 15.0 object library
« Reply #3 on: August 02, 2013, 03:29:45 AM »
In that case you need to be looking for Excel 14.0 Object Library.  Is there some specific 2013 functionality that you're trying to utilise?

Best regards

John
John Goldsmith - Visio MVP
http://visualsignals.typepad.co.uk/

chrismartz

  • Jr. Member
  • **
  • Posts: 16
Re: adding in excel 15.0 object library
« Reply #4 on: August 02, 2013, 06:53:03 PM »
Thanks John -

No I got an error message that said either 14.0 or 15.0 so I though I would go with the higher version. I'm not sure how to enable it. I go into add ins and that doesn't seem to be the right place and the documentation I've found on line says do it through the project in VB editor but that doesn't seem to be the right place either.

Any thoughts?

Chris

JohnGoldsmith

  • Sr. Member
  • ****
  • Posts: 357
    • John Goldsmith's visLog
Re: adding in excel 15.0 object library
« Reply #5 on: August 03, 2013, 05:57:13 AM »
Hello Chris,

It's under Tools / References, and that's what you're doing - your setting a reference to your installed version of Excel so that you can use this in your code.

Have a look at the attached screenshot and let me know if that helps.

Best regards

John 
John Goldsmith - Visio MVP
http://visualsignals.typepad.co.uk/

chrismartz

  • Jr. Member
  • **
  • Posts: 16
Re: adding in excel 15.0 object library
« Reply #6 on: August 03, 2013, 08:56:31 PM »
Thanks for you help again John - I'm up and running.

Chris

JohnGoldsmith

  • Sr. Member
  • ****
  • Posts: 357
    • John Goldsmith's visLog
Re: adding in excel 15.0 object library
« Reply #7 on: August 04, 2013, 04:59:55 AM »
That's great.  Glad that's helped.

Just one note on my code below, is that there's a typo in the GetObject syntax:

Code
GetObject("Excel.Application")

should read:

Code
GetObject(, "Excel.Application")

where the first argument is a null reference to the pathname.

See these two links for reference:

Best regards

John

John Goldsmith - Visio MVP
http://visualsignals.typepad.co.uk/