Ferd,

Someone may have a better solution, and I'll be interested to see it too.

My workaround is to define the XL variable in the other App, e.g. -

Const xlLastCell As Integer = 11

You can get the value by doing "?xlLastCell" in the Excel VBE immediate
window & you'll see the value is 11.


regards,

JohnI


"Ferd" wrote in message
...
When I run commands like:

ObjExcelApp.ActiveCell.SpecialCells(xlLastCell).Se lect

in Excel, they work fine. But when I try to run this
command in a Sax Basic program, calling it from another
program (SPSS), it doesn't understand "xlLastCell".

Is there some way of making SPSS understand these Excel
references?