EXCEL Problem

[techmanbd]

Ok, what is happening is that on the computer I am writing the code on, when I run it it works fine. The excel file opens.

BUT when I put it on another computer I get the error donw at the bottom.
Here is my code

Dim strExFile As String = strPath & "\filename.xls"
 Try
            exSheet = exApp.Workbooks.Open(strExFile).Worksheets(strWS)
        Catch ex As Exception
            MessageBox.Show("Couldnt open or find -" & strExFile & ". Error message = " & Err.Description & _
                            ". Error number = " & Err.Number)
            exApp.Quit()
            exSheet = Nothing
            exApp = Nothing
            GC.Collect()
            Exit Sub
        End Try
[CODE]

And I get this error

"Couldnt open or find -C:\Program Files\companyname\file\filename.xls. Error message = Object refernce not set to an instance of an object. Error Number = 91 "

 

[PlausiblyDamp]

Does the other computer have Excel installed on it? Also does the file exist in the correct place?
If you go to start->run and type in the path does excel open the correct file?

 

[techmanbd]

Yes, the machine has excel and I went and did the run and it comes up

 

[techmanbd]

I think I may have found my problem, On my computer I have the excel library 10.0 and on the other computer the excel version is 9.0

So how can I get this to work? without having to downgrade my ms office or upgrading to office xp on the other computer? license reason why.

 

[techmanbd]

Found my answer, here is a link for who ever has the same problem.

http://beta.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20697219.html

Talks about automation which is another term for late binding. I used this and it worked great