Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

old ? Excel

Status
Not open for further replies.

BoFenger

Programmer
Aug 6, 2003
22
DK
Hi TT
I have the following code to make a excel sheet
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

'Start a new workbook in Excel.
oExcel = CreateObject("Excel.Application")
oBook = oExcel.Workbooks.Add '***

oSheet = oBook.Worksheets(1)

but the line with *** fails and a error code says:
Old format or invalid type library.

I use Microsoft Excel 10.0 Object Library, I have excel 2002 SP2 (10.4524.4219), and I use VB .NET

Hope you can help me

\Bo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top