adding in excel 15.0 object library

Started by chrismartz, August 02, 2013, 02:54:59 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

chrismartz

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

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?


JohnGoldsmith

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

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

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

Thanks for you help again John - I'm up and running.

Chris

JohnGoldsmith

That's great.  Glad that's helped.

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

GetObject("Excel.Application")

should read:

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/