?
Solved

Excel Application with VB6.0

Posted on 2003-11-18
5
Medium Priority
?
385 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
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…
Suggested Courses
Course of the Month12 days, 3 hours left to enroll

752 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