Try this KB article to see if it helps you:
INFO: Troubleshooting Error 429 When Automating Office Applications
http://support.microsoft.com/?id=244264
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
> I am using an excel file which has macros in it, when ever i click the
> command button its gives the msg that Run-Time erroe '429' activex
> component can't create object.
> can any body help me on this, waiting for the replay