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