Envoyé par
bakarim
Bonjour craryb,
merci de m´ avoir repondu,
apres avoir ajoutee les classes de Typbibliotheque(Microsoft excel 11.0), c est cree automatiquement une classe CWorkbooks.h pour l interface Workbooks.Cette classe ne contient pas de Add-methode avec un seul parametre.
Voici un extrait de la classe CWorkbooks generee:
// Computergenerierte IDispatch-Wrapperklassen, die mit dem Assistenten zum Hinzufügen von Klassen aus der Typbibliothek erstellt wurden
/********************************************************
// CWorkbooks Wrapperklasse
#import "C:\\Programme\\Gemeinsame Dateien\\Microsoft Shared\\OFFICE11\\MSO.DLL" \
rename( "RGB", "MSORGB" )
using namespace Office;
#import "C:\\Programme\\Gemeinsame Dateien\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB"
using namespace VBIDE;
#import "C:\\Programme\\Microsoft Office\\OFFICE11\\EXCEL.EXE" \
rename("DialogBox", "ExclDialogBox") \
rename("RGB", "ExclRGB") \
rename("CopyFile", "ExclCopyFile") \
rename("ReplaceText", "ExclReplaceText") \
rename("Font", "ExcelFont") \
rename("Parameter", "ExcelParameter") \
rename("DocumentProperties", "ExcelDocumentProperties") \
rename("ExitWindows", "ExcelExitWindows") \
rename("Rectangle", "ExcelRectangle") \
rename("Arc", "ExcelArc") \
rename("Picture", "ExcelPicture")
class CWorkbooks : public COleDispatchDriver
{
public:
CWorkbooks(){}
CWorkbooks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
CWorkbooks(const CWorkbooks& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attribute
public:
// Vorgänge
public:
// IParameters Methoden
public:
Parameter get_Application()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH,
(void*)&result, NULL);
return result;
}
XlCreator get_Creator()
{
XlCreator result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)
&result, NULL);
return result;
}
LPDISPATCH get_Parent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH,
(void*)&result, NULL);
return result;
}
STDMETHOD(Add)(LPCTSTR Name, VARIANT& iDataType,
Parameter * * RHS)
{
HRESULT result;
static BYTE parms[] = VTS_BSTR VTS_VARIANT VTS_PDISPATCH ;
InvokeHelper(0xb5, DISPATCH_METHOD, VT_HRESULT, (void*)
&result, parms, Name, &iDataType, RHS);
return result;
}
long get_Count()
{
long result;
InvokeHelper(0x76, DISPATCH_PROPERTYGET, VT_I4, (void*)
&result, NULL);
return result;
}
STDMETHOD(Item)(VARIANT& Index, Parameter * * RHS)
{
HRESULT result;
static BYTE parms[] = VTS_VARIANT VTS_PDISPATCH ;
InvokeHelper(0xaa, DISPATCH_METHOD, VT_HRESULT, (void*)
&result, parms, &Index, RHS);
return result;
}
Parameter get__Default(VARIANT& Index)
{
Parameter result;
static BYTE parms[] = VTS_VARIANT ;
InvokeHelper(0x0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)
&result, parms, &Index);
return result;
}
STDMETHOD(Delete)()
{
HRESULT result;
InvokeHelper(0x75, DISPATCH_METHOD, VT_HRESULT, (void*)
&result, NULL);
return result;
}
STDMETHOD(_NewEnum)(LPUNKNOWN * RHS)
{
HRESULT result;
static BYTE parms[] = VTS_PUNKNOWN ;
InvokeHelper(0xfffffffc, DISPATCH_METHOD, VT_HRESULT, (void*)
&result, parms, RHS);
return result;
}
// IParameters Eigenschaften
public:
};
Partager