Re: Developer 2000 and OLE

Can you make Excel sheet visible on your screen from Forms 5?

Tony.

"S. Anthony Sequeira" wrote:

> Help !
> I am using forms5 with Excel 97, my problem is that I want use the excel
> constants,
> but so far without much luck.
> For example recording a macro in excel to find the last cell in the
> spreadsheet gives me :-
>
> Selection.SpecialCells(xlCellTypeLastCell).Select
>
> I use the msg_box to find the constant value of xlCellTypeLastCell which
> returns 11
>
> and this is where I then get stuck.
>
> If anyone has any examples, or has done this kind of thing before this would
> be greatly appreciated
>
> I have the oracle white paper, which is for excel 95 and does not work with
> 97 but I can get round
> using get_obj_property instead of invoke_property
>
> --
> --
> S. Anthony Sequeira
Received on Mon Jun 21 1999 - 00:02:19 CEST