Author | Topic: Excel ActiveX API | |
---|---|---|
Luiz E. Penna Fernandes | Excel 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_ OHR | Re: 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 Beling | Re: 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 |