excel instance in VB.NET

T

Tomek

Hi,
My next question is about excel instance in VB.NET
I have following code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
oXL = CreateObject("Excel.Application")
oWB = oXL.Workbooks.Add
I have following code on form top:
Imports Microsoft.Office.Core
And I've receive following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
Additional information: Old format or invalid type library.
This error appear in every line where I try to use oXL object.
I have installed excel 2000 and excell XP.
Any ideas?
Tomek
 
O

One Handed Man \( OHM - Terry Burns \)

Make sure you have the latest version of the COM interop DLL for Office, I thinks its Office 11 version 2.3

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Hi,
My next question is about excel instance in VB.NET
I have following code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
oXL = CreateObject("Excel.Application")
oWB = oXL.Workbooks.Add
I have following code on form top:
Imports Microsoft.Office.Core
And I've receive following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
Additional information: Old format or invalid type library.
This error appear in every line where I try to use oXL object.
I have installed excel 2000 and excell XP.
Any ideas?
Tomek
 
T

Tomek

OK. I have Office 10 version 2.2
Where I can find Office 11 version 2.3? I've try to find it on MS site but I can't. Please help.
Tomek

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message Make sure you have the latest version of the COM interop DLL for Office, I thinks its Office 11 version 2.3

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Hi,
My next question is about excel instance in VB.NET
I have following code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
oXL = CreateObject("Excel.Application")
oWB = oXL.Workbooks.Add
I have following code on form top:
Imports Microsoft.Office.Core
And I've receive following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
Additional information: Old format or invalid type library.
This error appear in every line where I try to use oXL object.
I have installed excel 2000 and excell XP.
Any ideas?
Tomek
 
P

Paul Clement

¤ Hi,
¤ My next question is about excel instance in VB.NET
¤ I have following code:
¤ Dim oXL As Excel.Application
¤ Dim oWB As Excel.Workbook
¤ Dim oSheet As Excel.Worksheet
¤ Dim oRng As Excel.Range
¤ oXL = CreateObject("Excel.Application")
¤ oWB = oXL.Workbooks.Add
¤ I have following code on form top:
¤ Imports Microsoft.Office.Core
¤ And I've receive following error:
¤ An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
¤ Additional information: Old format or invalid type library.
¤ This error appear in every line where I try to use oXL object.
¤ I have installed excel 2000 and excell XP.
¤ Any ideas?
¤ Tomek

See the following:

BUG: "Old Format or Invalid Type Library" Error When Automating Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;320369


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
O

One Handed Man \( OHM - Terry Burns \)

Paul seems to have hit the nail on the head with this one.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


OK. I have Office 10 version 2.2
Where I can find Office 11 version 2.3? I've try to find it on MS site but I can't. Please help.
Tomek

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message Make sure you have the latest version of the COM interop DLL for Office, I thinks its Office 11 version 2.3

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Hi,
My next question is about excel instance in VB.NET
I have following code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
oXL = CreateObject("Excel.Application")
oWB = oXL.Workbooks.Add
I have following code on form top:
Imports Microsoft.Office.Core
And I've receive following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
Additional information: Old format or invalid type library.
This error appear in every line where I try to use oXL object.
I have installed excel 2000 and excell XP.
Any ideas?
Tomek
 
T

Tomek

I don't want to install Office 2003 to get these files. I want to find some package with interesting files.
"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message Paul seems to have hit the nail on the head with this one.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


OK. I have Office 10 version 2.2
Where I can find Office 11 version 2.3? I've try to find it on MS site but I can't. Please help.
Tomek

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message Make sure you have the latest version of the COM interop DLL for Office, I thinks its Office 11 version 2.3

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Hi,
My next question is about excel instance in VB.NET
I have following code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
oXL = CreateObject("Excel.Application")
oWB = oXL.Workbooks.Add
I have following code on form top:
Imports Microsoft.Office.Core
And I've receive following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
Additional information: Old format or invalid type library.
This error appear in every line where I try to use oXL object.
I have installed excel 2000 and excell XP.
Any ideas?
Tomek
 
O

One Handed Man \( OHM - Terry Burns \)

Read Paul Clements post, he seems to have found and answer for you.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


I don't want to install Office 2003 to get these files. I want to find some package with interesting files.
"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message Paul seems to have hit the nail on the head with this one.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


OK. I have Office 10 version 2.2
Where I can find Office 11 version 2.3? I've try to find it on MS site but I can't. Please help.
Tomek

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message Make sure you have the latest version of the COM interop DLL for Office, I thinks its Office 11 version 2.3

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Hi,
My next question is about excel instance in VB.NET
I have following code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
oXL = CreateObject("Excel.Application")
oWB = oXL.Workbooks.Add
I have following code on form top:
Imports Microsoft.Office.Core
And I've receive following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
Additional information: Old format or invalid type library.
This error appear in every line where I try to use oXL object.
I have installed excel 2000 and excell XP.
Any ideas?
Tomek
 
T

Tomek

Thanks. That was a problem.

Paul Clement said:
¤ Hi,
¤ My next question is about excel instance in VB.NET
¤ I have following code:
¤ Dim oXL As Excel.Application
¤ Dim oWB As Excel.Workbook
¤ Dim oSheet As Excel.Worksheet
¤ Dim oRng As Excel.Range
¤ oXL = CreateObject("Excel.Application")
¤ oWB = oXL.Workbooks.Add
¤ I have following code on form top:
¤ Imports Microsoft.Office.Core
¤ And I've receive following error:
¤ An unhandled exception of type
Click to expand...
'System.Runtime.InteropServices.COMException' occurred in TestOnly.exe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening an 2003 Excel spreadsheet 3
Excel automation 6
Excel automation 14
Accessing existing Excel instance 3
Earlier post about excel.. Still not working.. Guru needed! 2
Insert Column in Excel in VB .NET 1
method 'add' of object 'workbooks' failed 3
Error when WB already open 2

Top