Excel ActiveX Install not working

[briancoats]

I have a program that opens an excel file in order to extract the data therein into a userdefined type. This all works well and good on my machine, as well as my bosses. My boss confidently sent this program to the user and after installing the program on his machine the inport from excel option locked up his computer totally and did so every time he clicked that button. So we put the install on another box we have here in the office and that one gives me an error when it tries to create an instance of excel.application.

Dimension like this: Dim xlApp as Excel.Application
Set like this: Set xlApp = New Excel.Application

Would anyone out there know anything about how to package this so that all the dependency files are there as I suppose they are not. I do know the the Excel.exe file is getting placed on the target box, though I am unsure which dlls or tlbs are necessary to carry this out. Oh and I was wondering if you might know if the Excel.exe needs to be in a specific location like maybe \Program Files\Microsoft Office\Office or Office10?

Thanks for any and all help.

Brian

"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime."

 

[CCLINT]

er, does the client pc where the error is happening have MS Excel installed?

 

[briancoats]

the client pc does our test pc in the office does not.

Brian

 

[CCLINT]

You are not authorized to distribute the Excel runtime files, Object Library, etc, via the VB license.

And, a licensed version of Excel needs to be on the machine in order for your reference to work.

 

[briancoats]

Thanks, we figured that out. that only other thing I would add is that it has to be a version at least as late as the developing computer. Thanks for the help.

Brian