problem exporting to excel... please help me....

[ganteng6pack]

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..

[BrianB]

I don't really know the answer, but having seen your query some time ago ...

the only thing I can think of is that a necessary .dll or other file is not available in the Windows 98 setup. eg. check Tools/References in the Visual Basic for Applications code Editor.

You have really posted in the wrong forum. You should be searching in Visual Basic (not VBA).