Solved

Excel Application with VB6.0

Posted on 2003-11-18
5
374 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA Excel: Copy Data from one workbook to another v6 csv extension 15 77
Input past end of file vbs script 9 82
VBA filters 2 51
VB6 ListBox Question 4 34
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now