Dim Value Set Value = CreateObject("RegEdit.Value") Value.SomeMethod SomeParameters Value.SomeProperty = SomeValue
You can also use CreateObject method method of Server object (ASP) to put the Value 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="Value" progid="RegEdit.Value"> </object>
Please use ActivexObject object in JScript/JavaScript to create Value object:
var Value; Value = new ActiveXObject("RegEdit.Value"); Value.SomeMethod(SomeParameters) Value.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 Value As New RegEdit.Value Value.SomeMethod SomeParameters Value.SomeProperty = SomeValue ...or
Dim Value As RegEdit.Value ... Set Value = New RegEdit.Value Value.SomeMethod SomeParameters Value.SomeProperty = SomeValue ...You can use CreateObject function also, of course:
Dim Value As RegEdit.Value ... Set Value = CreateObject("RegEdit.Value") Value.SomeMethod SomeParameters Value.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 Value objector (VBA)
RegEdit.Value Value = new RegEdit.ValueClass();
Value.set_String("Some text value");
String SQL;
SQL = "Insert Into Table (BinaryColumn) values (0x" + Value.get_HexString() + ")"; ...
Dim Value As New RegEdit.Value Value.SomeMethod(SomeParameters) Value.SomeProperty = SomeValue
DECLARE @Value INT, @OLEResult INT EXECUTE @OLEResult = sp_OACreate 'RegEdit.Value', @Value OUT IF @OLEResult <> 0 PRINT 'Error create component Value' --Set a property of Value. EXECUTE @OLEResult = sp_OASetProperty @Value, 'PropertyName', @SomeSQLValue IF @OLEResult <> 0 PRINT 'PropertyName set problem' --Get a value of a property of Value. EXECUTE @OLEResult = sp_OAGetProperty @Value, 'PropertyName', @SomeSQLValue OUTPUT IF @OLEResult <> 0 PRINT 'PropertyName get problem' --Call some method of Value. EXEC @OLEResult = sp_OAMethod @Value, 'MethodName', @ReturnValue OUTPUT, @parameter1, @parameter2
© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz