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