Re: OLE2 --> Excel

Two things to get it to work.
 application:=OLE2.CREATE_OBJ('Excel8.Application'); -- might make a difference, try as a last resort
 ole2.set_property(application,'Visible', 'True'); try 1 intead of 'TRUE' - I know this works with Word.
To test if Excel is open press CTRL-ALT-DEL and see if Excel is in the task list

Bert Vanderstraeten wrote:

> This code is supposed to open Excel : (Using MS Excel 97)
>
> In WHEN_BUTTON_PRESSED TRIGGER
>
> DECLARE
> application OLE2.OBJ_TYPE;
> BEGIN
> application:=OLE2.CREATE_OBJ('Excel.Application');
> ole2.set_property(application,'Visible', 'True');
>
> END;
>
> Instead it does nothing at all, disc activity however shows there must be
> something going on in background.
>
> Does anybody have any experience in this sort of thing?
>
> Thx a million
> Bert Vanderstraeten
Received on Wed Jun 23 1999 - 10:51:03 CEST