Install Problem

[briancoats]

Well,

I have an application that is accessing an excell file to omport data into my userdefined data type. When I am trying to install on the users computer it gives me an err. It says "Error regestering msado25.tlb" Any suggestions of how I can get this file or what to do about this?

Thanks in advance

Brian

 

[computerjin]

install MDAC2.5 or MDAC2.7 components on the user machine first, then install ur app on user machine.
hope this will help.

computerjin

 

[briancoats]

OK, we got that fixed, now I am getting the error that says "ActiveX Component cannot create object." when I run the program. Any ideas what to do about that. It there an alternative way to declare the excel objects other than

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = New Excel.Application
xlApp.SheetsInNewWorkbook = 1
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.ActiveSheet

in the actual application I am setting xlbook to an existing file. Any thoughts?

Thanks

Brian

 

[briancoats]

Would using CreateObject fix the problem and if so, what do I create? are these right?

CreateObjext("Excel.Application&quot
CreateObject("Excel.WorkBook&quot
CreateObject("Excel.Sheet&quot

Boy I would really like to get this to work.

Brian

 

[zemp]

The second error that you are getting is usually because a dll or ocx that the app requires was not distibuted or registered properly on the target computer. I would check my references and make sure that all required files exist on the target computer.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."