automation error in win 98

[knuckle]

i've coded a program that will generate an excel format in windows XP platform.. But when I run it in windows 98 there is an "automation erro".Is there any patches I can use to solve this prolem?

[lintz]

I'm in the same situation and would like to know if there is a solution.

[Lightning]

Differnt version from office installed, office installed at all?

[knuckle]

I created an excel base format in Office 2000 and when I tested it in win 98 I also created an excel base format in office 97...When I debug the progrma I can't open an excel object.. I do not know why.. Here's the error..

XLapp = nothing

Here's the way I declared my excel object....

Option Explicit
Global DBCONN As ADODB.Connection
Global DBCONNstr As String
Public XLapp As Object
Public XLbook As Object

Is there any other way to declare an excel application?

[lintz]

This is how I have declared Excel..

Public objExcel As Object 'instead of Excel.Application
Public oXLApp As Object  'instead of Excel.Spreadsheet

[knuckle]

okay!!! i'll just try to changed the declaration......