Hi All, I have a big problem rig

[Imshaad]

Hi All,

I have a big problem right now. I have developed an application in Excel VBA. I have the following codes for connecting to another Excel Sheet

Set cnConn = New Connection
With cnConn
.Provider = "MSDASQL"
.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};" & _
"DBQ=" & sEmpFilePath & ";"
.CursorLocation = adUseClient
.Open
End With

This works find on my development machine which is under win 2000. When I deploy the application under win 2000 it still works fine but under win 98 I get the following error:
Error Number: 3706
Description: Provider Cannot be found. It may not be properly installed.

Any hint how to get this resolved?

thanks you all.

 

[CooterBrown]

Excel is installed on 98 box?

 

[Imshaad]

Yes I have same version of Excel as on the Win2000.