I need to know the last row in a Excel document which I open from Power Point.
I'm doing something like this:
dim mybook as object
dim n as integer
mybook.application.visible = true
That part is working perfectly, open the book, read some cells, is fine, but
I can't use this instruction (which work perfectly in Excel):
n = mybook.application.ActiveCell.End(xlDown).Row
Someone knows why? Is there another way to find out the last cell using a
similar instruction or simply it is impossible to use Excel VBA from
PowerPoint VBA? Another idea to get the last row besides reading line by line?