VB 6.0 - Creating installer for the project

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

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 

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

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.

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. 

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. 

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.

i dont get it. we can create installer only if we had created exe for the project and the exe is the application .

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

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.