ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What library is xlLocationAsObject in for use in VB.NET? (https://www.excelbanter.com/excel-programming/334476-what-library-xllocationasobject-use-vbulletin-net.html)

Nick Dreyer

What library is xlLocationAsObject in for use in VB.NET?
 
In VB.NET I imported Excel and Graph libraries,
but xlLocationAsObject is found in neither.
Where is it? Also, can anyone tell me an easy way to find out
which library contains a given name like this? (so I won't
need to bother a newsgroup about this next time!)

Thanks in advance,


|\|.

Rob Bovey

What library is xlLocationAsObject in for use in VB.NET?
 
"Nick Dreyer" wrote in message
...
In VB.NET I imported Excel and Graph libraries,
but xlLocationAsObject is found in neither.
Where is it? Also, can anyone tell me an easy way to find out
which library contains a given name like this? (so I won't
need to bother a newsgroup about this next time!)


Hi Nick,

According to the VBA Object Browser, xlLocationAsObject is one of three
XlChartLocation enumeration values in the Excel object library. No idea why
it doesn't show up in VB.NET, but you can substitute its value, the number
2, for it if you need to (this information can also be found in the VBA
Object Browser).

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm




All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com