![]() |
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 |
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 |
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 |
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 |
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 |
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