otakung
Junior Member level 3
VB6 Problem Again!!
I use WinXP & Office XP for run VB6 & add Microsoft Excel Object Library 10.0 to run this code. =>
Dim objExcel as Excel.Application
Set objExcel = New Excel.Application
objExcel.SheetsInNewWorkBook = 1
objExcel.WorkBooks.Add
objExcel.Visible = True
objExcel.Cells(1,1) = "Name"
It can run properly because I can see in Excel, but when I use this code with Win98 & Office 97. It says "Run Time Error" & "Automation Error".
How should I do for this case?
I use WinXP & Office XP for run VB6 & add Microsoft Excel Object Library 10.0 to run this code. =>
Dim objExcel as Excel.Application
Set objExcel = New Excel.Application
objExcel.SheetsInNewWorkBook = 1
objExcel.WorkBooks.Add
objExcel.Visible = True
objExcel.Cells(1,1) = "Name"
It can run properly because I can see in Excel, but when I use this code with Win98 & Office 97. It says "Run Time Error" & "Automation Error".
How should I do for this case?