ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Library? (https://www.excelbanter.com/excel-programming/367373-excel-library.html)

MaxS

Excel Library?
 
Anyone knows how Excel 2002 (version 10) object library is called? Need
to make a reference to it fom VS.

Thank you!
Maxs


NickHK

Excel Library?
 
Version 9 appears as "Microsoft Excel 9.0 Object Library" in VBA/VB6
reference list, so I would assume 10 is similar.
Or you mean:
Set XLObj=CreateObject("Excel.Application.10")

NickHK

"MaxS" wrote in message
oups.com...
Anyone knows how Excel 2002 (version 10) object library is called? Need
to make a reference to it fom VS.

Thank you!
Maxs




MaxS

Excel Library?
 
Thanks NickHK,

I have just found after two days searching that the file is excel.exe
itself rather than "something.dll" or " "something.olb". In terms of
naming - yes it appears as
"Microsoft Excel 10.0 Object Library" in references. However VS says
that it cannot find it, a.k.a the file does not exist...


NickHK wrote:

Version 9 appears as "Microsoft Excel 9.0 Object Library" in VBA/VB6
reference list, so I would assume 10 is similar.
Or you mean:
Set XLObj=CreateObject("Excel.Application.10")

NickHK

"MaxS" wrote in message
oups.com...
Anyone knows how Excel 2002 (version 10) object library is called? Need
to make a reference to it fom VS.

Thank you!
Maxs



NickHK

Excel Library?
 
Making a reference to Excel, shows the actual file to be:
C:\Program Files\Microsoft Office\Office\Excel9.olb

But the reference should come up in the list, so the actual file name is
somewhat irrelevant.
However, as said before, the Dotnet groups would may be have an answer.

NickHK

"MaxS" wrote in message
ups.com...
Thanks NickHK,

I have just found after two days searching that the file is excel.exe
itself rather than "something.dll" or " "something.olb". In terms of
naming - yes it appears as
"Microsoft Excel 10.0 Object Library" in references. However VS says
that it cannot find it, a.k.a the file does not exist...


NickHK wrote:

Version 9 appears as "Microsoft Excel 9.0 Object Library" in VBA/VB6
reference list, so I would assume 10 is similar.
Or you mean:
Set XLObj=CreateObject("Excel.Application.10")

NickHK

"MaxS" wrote in message
oups.com...
Anyone knows how Excel 2002 (version 10) object library is called?

Need
to make a reference to it fom VS.

Thank you!
Maxs





Chip Pearson

Excel Library?
 
The version 10 type library is part of Excel.exe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"MaxS" wrote in message
oups.com...
Anyone knows how Excel 2002 (version 10) object library is
called? Need
to make a reference to it fom VS.

Thank you!
Maxs




MaxS

Excel Library?
 
Thanks a lot, Chip!
Chip Pearson wrote:
The version 10 type library is part of Excel.exe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"MaxS" wrote in message
oups.com...
Anyone knows how Excel 2002 (version 10) object library is
called? Need
to make a reference to it fom VS.

Thank you!
Maxs




All times are GMT +1. The time now is 02:36 PM.

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