R
Roberto
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
Set mybook("excel.xls")
mybook.application.visible = true
myboook.sheets("sheet1").select
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?
I'm doing something like this:
dim mybook as object
dim n as integer
Set mybook("excel.xls")
mybook.application.visible = true
myboook.sheets("sheet1").select
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?