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
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?
No Excel 2010.
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
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
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
Thanks for you help again John - I'm up and running.
Chris
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:
- GetObject (http://msdn.microsoft.com/en-us/library/gg251785%28v=office.14%29.aspx)
- CreateObject (http://msdn.microsoft.com/en-us/library/gg264813%28v=office.14%29.aspx)
Best regards
John