VFP5 and 7: Determine last row of a Excel spreadsheet

[cj001]

Hello,

I have an Excel file with spreadsheets of varying lengths.

How do i determine what is the last row of an Excel spreadsheet?

THANKS!
CJ

 

[Mike Lewis]

CJ,

I take it you mean the last row actually used. If so, how about something like this:

oExcel.Selection.SpecialCells(11).Select

That will move the pointer to the last row used. You can then look at the active cell's row number.

If that doesn't work, and if you don't get a better answer, try posting in an Excel or VBA-related forum, as it's not really a VFP issue.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[cj001]

I creating these worksheets originally with VFP.

Yes, I am looking for the last row actually used.

 

[Mike Lewis]

CJ,

OK, give it a try.

MIke


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[danceman]

' Get the number of rows of the selection.
RowCount = Selection.Rows.Count
' Get the number of columns of the selection.
ColumnCount = Selection.Columns.Count
' Activate the last cell of the selection.
Selection.Cells(RowCount, ColumnCount).Activate

Attitude is Everything