Dim ConnectionTypes Set ConnectionTypes = CreateObject("EmailExport.ConnectionTypes") ConnectionTypes.SomeMethod SomeParameters ConnectionTypes.SomeProperty = SomeValue
You can also use CreateObject method method of Server object (ASP) to put the ConnectionTypes object to page scope or CreateObject method of WScript object in WSH.
You can also put the object to Application or Session scope using <object ...> tag in global.asa
<object runat="server" scope="application" id="ConnectionTypes" progid="EmailExport.ConnectionTypes"> </object>
Please use ActivexObject object in JScript/JavaScript to create ConnectionTypes object:
var ConnectionTypes; ConnectionTypes = new ActiveXObject("EmailExport.ConnectionTypes"); ConnectionTypes.SomeMethod(SomeParameters) ConnectionTypes.SomeProperty = SomeValue ...
VBA 5/6: You can reference the library using menu Project -> References
-> select 'Email Account Export library' in the listbox (or Project ->
References -> Browse -> select EmailEx.DLL file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools
-> References
Then you can write:
Dim ConnectionTypes As New EmailExport.ConnectionTypes ConnectionTypes.SomeMethod SomeParameters ConnectionTypes.SomeProperty = SomeValue ...or
Dim ConnectionTypes As EmailExport.ConnectionTypes ... Set ConnectionTypes = New EmailExport.ConnectionTypes ConnectionTypes.SomeMethod SomeParameters ConnectionTypes.SomeProperty = SomeValue ...You can use CreateObject function also, of course:
Dim ConnectionTypes As EmailExport.ConnectionTypes ... Set ConnectionTypes = CreateObject("EmailExport.ConnectionTypes") ConnectionTypes.SomeMethod SomeParameters ConnectionTypes.SomeProperty = SomeValue ...
You can reference the library using menu Project -> Add reference -> COM tab -> select 'Email Account Export library' in the listbox -> click Select. Then you can write (C#, J#):
//create a new ConnectionTypes objector (VBA)
EmailExport.ConnectionTypes ConnectionTypes = new EmailExport.ConnectionTypesClass();
ConnectionTypes.set_String("Some text value");
String SQL;
SQL = "Insert Into Table (BinaryColumn) values (0x" + ConnectionTypes.get_HexString() + ")"; ...
Dim ConnectionTypes As New EmailExport.ConnectionTypes ConnectionTypes.SomeMethod(SomeParameters) ConnectionTypes.SomeProperty = SomeValue
DECLARE @ConnectionTypes INT, @OLEResult INT EXECUTE @OLEResult = sp_OACreate 'EmailExport.ConnectionTypes', @ConnectionTypes OUT IF @OLEResult <> 0 PRINT 'Error create component ConnectionTypes' --Set a property of ConnectionTypes. EXECUTE @OLEResult = sp_OASetProperty @ConnectionTypes, 'PropertyName', @SomeSQLValue IF @OLEResult <> 0 PRINT 'PropertyName set problem' --Get a value of a property of ConnectionTypes. EXECUTE @OLEResult = sp_OAGetProperty @ConnectionTypes, 'PropertyName', @SomeSQLValue OUTPUT IF @OLEResult <> 0 PRINT 'PropertyName get problem' --Call some method of ConnectionTypes. EXEC @OLEResult = sp_OAMethod @ConnectionTypes, 'MethodName', @ReturnValue OUTPUT, @parameter1, @parameter2
© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz