Error while opening excel v9.0 (2000) workbook in .NET

[dimple]

I have built a program in C# .NET that opens an excel spreadsheet and retrieves data from the sheet. The program works fine on my development machine, which is Windows 2000 and Excel 10.0 (2002). when I try and run it the production machine i get errors. The production machine is running excel 9.0 and windows 2000.

The error is at the following code.

xlApp = CreateObject("Excel.Application")

xlApp.Workbooks.Open(fileName:="G:\" & fileName) (ERROR IS HERE)

xlSheet = xlApp.Worksheets(1)

can anyone advice

 

[littleisharp]

Hi Dimple,

If your app has to support v9.0, you should develop and compile it on a machine that runs 9.0. See this:

INFO: Writing Automation Clients for Multiple Office Versions
http://support.microsoft.com/default.aspx?scid=kb;EN-US;244167

However, this may not nec. be the source of your problem as Im also getting this error....

 

[littleisharp]

However, this may not nec. be the source of your problem as Im also getting this error....

I also get the same problem, but have posted it to a different thread to avoid cross-posting:

http://www.computerhelp.forum/showthread.php?p=411787

 

[techmanbd]

Actually the best way to do that is called late binding instead of having to develop and compile on a machine that runs 9.0. What would be the point of that.

If you goto this link it talks about it and gives an example.
http://beta.experts-exchange.com/Pr...Q_20697219.html