VB 6.0 - Creating installer for the project - Asked By Arunprakash panchanathan on 03-Feb-12 04:41 AM

Hi

my application (VB 6.0) uses microsoft excel object library 12.0 .when i create an installer for my application with windows installer of visual studio and install in other computer which doesn't have msoffice installed then my application gets installed and runs perfect but if the event is triggered where the excel object is called then it gives an error 429 activex component can't create object.
Where as if i create an installer using visual basic 6.0 package and deployment tool then i dont find any problem in running the program even without MS office installed in the computer.can any one suggest a solution so that i can use the windows installer for creating installer for my application.

Thanks

AP
kalpana aparnathi replied to Arunprakash panchanathan on 03-Feb-12 04:45 AM
hi,

please add reference to Microsoft DAO 3.6 Object Library instead of Microsoft DAO 3.51 Object Library in your project

Thanks,
Web Star replied to Arunprakash panchanathan on 03-Feb-12 04:47 AM
This should explain everything in detail http://www.developer.com/net/vb/article.php/10926_1539871_3 
also this good one on eggheadcafe itself
http://www.eggheadcafe.com/community/vb6/8/10241352/vb-60-setup-file-creation.aspx 
Danasegarane Arunachalam replied to Arunprakash panchanathan on 03-Feb-12 04:47 AM
1. Are you using any excel automation or excel related stuff ?
2.If the application runs good on machine without Excel library then why do you include in your project ?
3.Remove the excel library and recreate the package and deploy
4.I doubt you are doing some automation then while instantiating the excel object you get the exception.

Check the coding
Arunprakash panchanathan replied to kalpana aparnathi on 03-Feb-12 04:54 AM
DAO 3.6 obj lib already added. this is related to creating setup / installer package for my application. i think the dependencies related to excel is not getting added up when i create installer using visual studio.
Arunprakash panchanathan replied to Web Star on 03-Feb-12 05:16 AM
yes i agree it works if i create packages using package and deployment. i want to use windows installer of visual studio 2008 to create my package.i've suceeded in adding all the other dep like crystal reports and etc.i got only stuck up with this excel obj lib and that to i came to know only after running the apps and executing the event. actually in the event i've writen program to export data from db to a excel file. 
Arunprakash panchanathan replied to Danasegarane Arunachalam on 03-Feb-12 05:20 AM
i have created a package of my vb6.0 application using widows installer of visual studio 2008. i've suceeded in adding all the file and dependencies but the thing is the file or dependency or interop related to ms office is not getting added when i build my setup project. i think now my question is bit clear. 
Web Star replied to Arunprakash panchanathan on 03-Feb-12 05:22 AM
Install create exe it doesn't matter which event are using in that application or not so your specific task should be code in you application first after that you create install project for that.
Arunprakash panchanathan replied to Web Star on 03-Feb-12 05:31 AM
i dont get it. we can create installer only if we had created exe for the project and the exe is the application .
Danasegarane Arunachalam replied to Arunprakash panchanathan on 07-Feb-12 07:45 AM
If your installer not adding the referenced item then you could force the deployer to add items for your

Right click on the Application Folder- Add-Add file method to add the dependencies in your application


Arunprakash panchanathan replied to Danasegarane Arunachalam on 08-Feb-12 01:52 AM
for excel object library we can't add dependencies as it is not available so i've tried adding the PIA but still it doesn't work. Anyways now i'm not using object library anymore instead i've gone for ADO concept to get and put data into excel file and with this i am able to create installer and it works successfully. thanks all.