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

Thank you!
Maxs

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

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

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

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

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