Hi all,

I have create a program using VB6, I used Win XP & Office XP. The problem is when I used it in Win 98 & Office XP I can't export my data from VB to excel. Here is the source code:

Dim excApp as Excel.Application

Private Sub Form_Load()
set excApp = new Excel.Application

excApp.Workbooks.Add
excApp.ActiveWorkbook.ActiveSheet.Cells(1,1).Value="TEST"

set excApp = Nothing
End Sub

I got no problem at all in WinXP, but in Win98 I got error "Error Automation"... anyone please help me asap....

thanx a lot guys..