Excel references in another program
 

Unless you create a reference to the Excel object library, the app won't
know what the definition of the constants are.

It can late bind without a reference and find out what the objects and so
forth are.

I haven't tried it but see what happens if you do

ObjExcelApp.ActiveCell.SpecialCells(Excel.Constant s.xlLastCell).Select

in your current code.

--
Regards,
Tom Ogilvy

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?