Link to home
Start Free TrialLog in
Avatar of lamdor
lamdor

asked on

Excel Application with VB6.0

Hi all,

 I have developed an application. In that I have been provided an option for the user to import data from the listview control to Excel file. I have done that as follows
Dim  excelapp as Excel.Application
excelApp = new Excel.Application
....
..

 In my system the excel object is linked with excel10 version. If I make the application package and install that in some other system the export does not work.. I think this is problem with excel version...

 Is there anyway to create excel file with out using the excel.application.

 Thankyou in advance..

With regards,
lam.

Avatar of lamdor
lamdor

ASKER

The above works good in system..but the problem is only in other systems..
use late binding


remove excel references

and use

Dim  excelapp as object
set excelApp = createobject("Excel.Application")


This way is version independent
ASKER CERTIFIED SOLUTION
Avatar of lamdor
lamdor

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial