Remotely with PowerShell

Back to index page

PowerShell supports working with the registry remotely. JChem for Excel provides a simple script that shows how to enable automation add-in on remote computers by administrators. The script file is in the Admin Guide folder under the JChem for Excel installation folder.

 

To run this script we need PowerShell installed. The script needs a list of users stored in a file as a parameter and will enable the automation add-in in all installed Excel instances.

 

.\EnableAutomationAddin.ps1 /RemoteSidList <file>

 

The file should contain the users in the following form:

 

<machine-name>\<SID-of-the-user>

 

For example:

 

LAB1\S-1-5-21-3842236448-1344586221-320078511-1000

LAB1\S-1-5-21-3842236448-1344586221-320078511-1007

LAB2\S-1-5-21-3842236448-1344586221-320078511-1011

LAB2\S-1-5-21-3842236448-1344586221-320078511-1033

LAB2\S-1-5-21-3842236448-1344586221-320078511-1011

 

The script will report the result of each user and each Excel instance.

 

Please note that Remote Registry service needs to be enabled on the remote machines and some extra firewall settings may also be necessary.

 

Back to index page