Form Builder 5.0 to Excel OLE-automation
Date: Fri, 15 Oct 1999 21:37:18 +0200
Message-ID: <epv7u7.09.ln_at_localhost>
Hello all,
I can't seem to get this to work: to start MS-Excel out of a form using OLE with the OLE2-package. The following should do the trick:
declare
application OLE2.OBJ_TYPE;
workbooks OLE2.OBJ_TYPE;
etc...
begin
application := OLE2.CREATE_OBJ('Excel.Application');
ole2.set_property(application,'Visible', 'True');
workbooks := OLE2.GET_OBJ_PROPERTY(application, 'Workbooks');
etc...
end;
It seems to start Excel allright, but on the 'workbooks'-statement raises an ole2.ole_error exception. The error-number is 6, which says something about 'overload'. Any ole2-statement issued in this place on the 'application'- object raises the same exception.
Hard/Software: Form Builder 5.0.6.16.0 on a Windows NT workstation and Excel7.0a
Anybody a clue? Received on Fri Oct 15 1999 - 21:37:18 CEST