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("Couldn't 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

 

"Couldn't 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