Hello

Thanks for all answers to my previos question!

I've open a workbook and correct sheet, and I've found the last cell. My problem now is no to save the cell's adress in the sheet so I can get it back with help of infile and input.

GETCELL don't have a equality in Visual Base-commands, so its not possible to use, ref help in Excel.

CODE:

filename com dde 'excel|system';

data _null_; file com; PUT '[OPEN("H:\fokuscad\excell\Renteopsjoner (CAPS,FLOOR, FRA).xls")]'; PUT '[WORKBOOK.SELECT("FLOORS", "FLOORS")]'; PUT '[SELECT.LAST.CELL()]'; PUT '[CLOSE()]'; run;

Greetings from Therese