excel9.olb problem

[VBmim]

I want to open excel from visual basic form with the following code:

Dim excApp As Excel.Application
Set excApp = New Excel.Application
excApp.Visible = True
excApp.SheetsInNewWorkbook = 1
excApp.Workbooks.Add

I get the following error message: Variable uses an Automation Type not supported in Visual Basic

The file excel9.olb is checked in the project's references.

Can anyone help me?

tnx in advance

Mim

 

[HermanvLimbeek]

Hi,

I ran this code with excel8.olb. No problems. You're sure the fault is in this piece of code? And what line? You can step through the code and see which statement generates the error.

Herman :-Q

 

[JohnYingling]

I drop "early binding" for production to avoid down-level Office version problems.

#Constant blnEarly = True  ' Use Intellisense
#if blnEarly then
    Dim excApp As Excel.Application
#else
    Dim excApp As Object
#End if
Set excApp = CreateObject("Excel.Application")

http://WWW.VBCompare.Com

 

[VBmim]

Yep, this works!!
I found out that the excel8.olb was replaced with excel9.olb when I ran a patch for Visual Basic.
The only problem is that I don't use excel 2000 yet (excel9.olb is for excell 2000).
Never trust patches...

Mim ;-)