lamdor
asked on
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.
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.
use late binding
remove excel references
and use
Dim excelapp as object
set excelApp = createobject("Excel.Applic ation")
This way is version independent
remove excel references
and use
Dim excelapp as object
set excelApp = createobject("Excel.Applic
This way is version independent
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER