• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

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.

0
lamdor
Asked:
lamdor
  • 2
1 Solution
 
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
 
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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now