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.

LVL 1
lamdorAsked:
Who is Participating?
 
lamdorAuthor Commented:
Hi,

 I got solution for the problem..

 I was developing the system in english version of windows and packing the application on english version itself. But, I was testing on japanese version of windows thats the problem since it is having excel also in japapanese.

 So, What I did is I have made two installation types english(packed on windows english version), javapanese(packed on japanese version).

 It is working nice..

 Thanks a lot..

lsm
0
 
lamdorAuthor Commented:
The above works good in system..but the problem is only in other systems..
0
 
EDDYKTCommented:
use late binding


remove excel references

and use

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


This way is version independent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.