Problem with excel 97
-
Hi all i am trying to automate MSEXcel.. i hav win2K as OS and Excel version is 97 i hav added the reference as Excel 8.0 ... Now when i try to open the Excel Work book, it gives out an exception (COMException).... but when i try the same caode in excel 2000 with Excel 9.0 as reference i am able to do ... i am using .netframework 2.0 ... is it not compatible with excel 97??? is there any way to solve this problem??? Thanks Akhil
-
Hi all i am trying to automate MSEXcel.. i hav win2K as OS and Excel version is 97 i hav added the reference as Excel 8.0 ... Now when i try to open the Excel Work book, it gives out an exception (COMException).... but when i try the same caode in excel 2000 with Excel 9.0 as reference i am able to do ... i am using .netframework 2.0 ... is it not compatible with excel 97??? is there any way to solve this problem??? Thanks Akhil
AnnnS wrote:
is there any way to solve this problem???
By providing more details.
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed
-
AnnnS wrote:
is there any way to solve this problem???
By providing more details.
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed
When i try to open the Workbook... ie Excel.Workbook wb= wbs.open("abc.xls",Type.missing .........) At this line error Occurs ... System.Runtime.InteropServices.COMException (0x8007F808): Exception from HRESULT: 0x8007F808 at Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru) this is the Error Message....
-
When i try to open the Workbook... ie Excel.Workbook wb= wbs.open("abc.xls",Type.missing .........) At this line error Occurs ... System.Runtime.InteropServices.COMException (0x8007F808): Exception from HRESULT: 0x8007F808 at Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru) this is the Error Message....
Two things I can think of at the moment 1) Make sure all the parameters are correct and that the file exists. 2) Make sure your Main function is marked with the STAThread attribute.
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed
-
Two things I can think of at the moment 1) Make sure all the parameters are correct and that the file exists. 2) Make sure your Main function is marked with the STAThread attribute.
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed
hi... thanx for the response ... As u told i hav checked everything ... everything seem to be correct ... i hav added STAThread Attribute also ... My Concern is when i do the same operation in one pc with excel 2000 installed with Microsoft Excel 9.0 Object Library , it works fine ... but when i try it in another pc with Excel 97 installed with Microsoft Excel 8.0 Object Library reference , it gives the Above given exception ... for last one week i hav been struggling with this problem ... plz help .. Thanks Akhil
-
hi... thanx for the response ... As u told i hav checked everything ... everything seem to be correct ... i hav added STAThread Attribute also ... My Concern is when i do the same operation in one pc with excel 2000 installed with Microsoft Excel 9.0 Object Library , it works fine ... but when i try it in another pc with Excel 97 installed with Microsoft Excel 8.0 Object Library reference , it gives the Above given exception ... for last one week i hav been struggling with this problem ... plz help .. Thanks Akhil
Are you sure that the spreadsheet is a compatible version, i.e. it can be opened normally in Excel 97?
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed
-
Are you sure that the spreadsheet is a compatible version, i.e. it can be opened normally in Excel 97?
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed
-
Open in Excel 97 manually and see :doh:
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9 Ed