Alaska Software Inc. - Excel ActiveX API
Username: Password:
AuthorTopic: Excel ActiveX API
Luiz E. Penna FernandesExcel ActiveX API
on Mon, 28 Jan 2013 15:45:50 -0200
Hi everyone,

To interact with Excel using the Xbase++ ActiveX package we need to know 
the structure and functioning of the Excel ActiveX API (the objects, 
methods, properties, etc).  Does anyone know where we can find this 
documentation?  I've searched the Web without any luck so far.  I'd also 
need a description of how the several types in the ActiveX API translate 
into the Xbase++ language. Could anyone help with these matters?

I'm more interested in Excel 2003 and 2007.

Any help will be fully appreciated.

Regards,
Luiz
AUGE_ OHRRe: Excel ActiveX API
on Mon, 28 Jan 2013 21:28:34 +0100
hi,

> To interact with Excel using the Xbase++ ActiveX package we need to know 
> the structure and functioning of the Excel ActiveX API (the objects, 
> methods, properties, etc).  Does anyone know where we can find this 
> documentation?

you will find it in Excel VBA Help File when press F1

> I'd also  need a description of how the several types in the ActiveX API 
> translate into the Xbase++ language.

do you meen Excel description "NumberFormat" ?

return Value of activeX can be Type "C","N","D" ( as YYYYMMDDHHMMSS )
or a Array which can be a "Collection".

greetings by OHR
Jimmy
Carlos Antonio BelingRe: Excel ActiveX API
on Tue, 29 Jan 2013 10:07:19 -0200
Hello Luiz:
good morning.
Many time ago I received the attached vars description that I hope it 
can to be useful for you

Beling
HTH

Em 28/1/2013 18:28, AUGE_ OHR escreveu:
> hi,
>
>> To interact with Excel using the Xbase++ ActiveX package we need to know
>> the structure and functioning of the Excel ActiveX API (the objects,
>> methods, properties, etc).  Does anyone know where we can find this
>> documentation?
>
> you will find it in Excel VBA Help File when press F1
>
>> I'd also  need a description of how the several types in the ActiveX API
>> translate into the Xbase++ language.
>
> do you meen Excel description "NumberFormat" ?
>
> return Value of activeX can be Type "C","N","D" ( as YYYYMMDDHHMMSS )
> or a Array which can be a "Collection".
>
> greetings by OHR
> Jimmy
>
>
>


Vars.txt