Environment problem!

[Lyubomyr]

Hi!
I have a problem. Probebly it is environment problem.

I need to generate Excel report from my VB.net application.
So, I connected the Excel refernce.
On the line:

_Workbook workbook = workbooks.Add (XlWBATemplate.xlWBATWorksheet);
[\code]
program terminates and i have:
Old format or invalid type library exception

I tried standart samples from MSDN I have the same
Scaned internat all samples give me the same exception

I suppose that it's something wrong with Environment settings

Please help.
Hope you get your tip

 

[chmohan]

can you look at this? Its in C# but you can convert to vb.net

http://www.c-sharpcorner.com/Code/2004/Feb/ReportsInDotNet.asp

 

[TipGiver]

VB.NET application and you use : _Workbook workbook = workbooks.Add (XlWBATemplate.xlWBATWorksheet); ?
It is rather a C# syntax, so no need to convert

 

[Lyubomyr]

My bad the I placed from identical code which i wrote in C#

my code in vb.net looks like this

        Dim xlApp As Excel.ApplicationClass
        Dim xlWb As Excel.WorkbookClass
        Dim xlSh As Excel.WorksheetClass

        xlApp = CreateObject("Excel.Application")
        xlApp.Visible = True

        xlWb = xlApp.Workbooks.Add()

By the way i still thick that is the environment problem. I scaned the problem in the i-net and found on the microsoft a tip which says that it should be installed .NET Programmability Support in my MS Office I did so but the problem remained.

Exception :
Old format or invalid type library

 

[ThatRickGuy]

Question, what library are you using? and what version of office do you have installed. I'm not positive on this, but if you are using the Offce 9 library, but have Office XP installed, you may get an old format/invalid lib error.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[Lyubomyr]

The problem is that I use Microsoft Excel 11.0 Object Library. And I use Office 2003

 

[chrissie1]

thats fine

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[Lyubomyr]

yes it is . But it doesn't work

- exception:
Old format or invalid type library

 

[ThatRickGuy]

I'd say remove the references and try either other excel/office libraries, or just re-add those libs. It really sounds to me like the issue is the lib you are using does not match the version of office you have installed.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.