Thanks very much for your reply. I tried this and this is what I got:
--------------------------------------------
cFile = GETFILE()
oExcel = CREATEOBJECT('Excel.Application')
oExcel.WorkBooks.Open(cFile)
oExcel.Worksheets(1).Activate
oExcel.SendKeys ("^+{END}",-1)
?oExcel.ActiveWindow.RangeSelection.Address
--------------------------------------------
Result: $A$1
When I manually open the workbook, CTRL + END brings me to $R$44
oExcel.ActiveWindow.ActiveCell.Value returns the value of the cell $A$1
oExcel.ActiveWindow.ActiveSheet.Name returns the name of the correct sheet
(there are 31 sheets in this workbook and I have to process all of them)
--------------------------------------------
Am I referencing the object correctly?
TIA
Charles Richard