Re: How to open an excel file

Correct.  Actually, it's a collection -- that is one-based!  So be
careful.

--
Patrick Steele
http://weblogs.asp.net/psteele



-----Original Message-----
From: Discussion forum for developers using Windows Forms to build apps
and controls [mailto:[email protected]] On Behalf Of
Hugh Brown
Sent: Monday, March 19, 2007 3:39 PM
To: [email protected]
Subject: Re: [DOTNET-WINFORMS] How to open an excel file


Workbook.Sheets is an array of sheets, no? You probably mean something
like .ActiveSheet.

Steve Abaffy <[email protected]> wrote: Ok that got me past that
problem but I have new one. Here is the code:

[...]
private Microsoft.Office.Interop.Excel._Worksheet Sheets;
[...]
Sheets = (Microsoft.Office.Interop.Excel._Worksheet)Workbook.Sheets;
//Error Here Range = Sheets.get_Range("A1", "AZ1"); } This complies but
errors out at the point shown

What am I doing wrong, this really shouldn't this hard.