Solved

Excel Application with VB6.0

Posted on 2003-11-18
5
378 Views
Last Modified: 2010-05-01
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
Comment
Question by:lamdor
  • 2
5 Comments
 
LVL 1

Author Comment

by:lamdor
ID: 9769914
The above works good in system..but the problem is only in other systems..
0
 
LVL 26

Expert Comment

by:EDDYKT
ID: 9770613
use late binding


remove excel references

and use

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


This way is version independent
0
 
LVL 1

Accepted Solution

by:
lamdor earned 0 total points
ID: 9854625
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question