Reading a remote registry from Excel

Microsoft OFFICE

    Sponsored Links


  • 1. VBA in Outlook accessing Subfolders in Public Folders
    Hi all, I am trying to write a few macros that will allow my customer to add contacts to 2 different folders in public folders/All Public Folders. The sub folders are all set to hold contact items. What I can't figure out is how would I add a new contact to these folders, and how would I access the contacts in these folders using another macro? I can't find anything in the help files that tell me anything about it. All help is appreciated, and thanks in advance. Brad Simon Symasytes Computer Solutions
  • 2. help!
    I am just starting to learn vb and want to develop an application which is useful while I am learning (to make it more interesting so I keep it up!). I want to retrieve some information from an ODBC datasource which is alredy set up on my computer. I have used excel to create queries before - can I use something similar to a SQL statement in VB and if so what statement do I use? Also, how do I put this information into the correct variables? Thanks for you help, Duncan
  • 3. Lotus Notes
    Hello, Is there a way to integrate/sync an MS-Access 97 application/database with Lotus Notes through VBA or VBScript??? If so, where can I find a book or examples???
  • 4. VBA excel cell editing
    I'm trying to modify a large excel document (60k+ rows), to change one thing in each cell. You may say just use the find and replace, but that changes the data in the cell. What I have got is the time each Item took to do but what gets put in to the xls file (I can not change this from the raw data) is eg. "' 0:55:28 s" I can remove the " s" using the find and replace but when I try to remove the "'" it changes the data to "12:55:28 pm". When I click on the cell manually and remove the "' " it dose not change the data. I tried to write a VBA macro but have had no luck (endless loops and so on). Thank you.

Reading a remote registry from Excel

Postby jinbru » Thu, 13 Nov 2003 05:21:03 GMT

I am trying to use VBA to read a list of remote servers stored in an
Excel column.

I have loaded several functions found on the net but I cannot get the
right values returned.

Does anyone have a some code that can do this or supply some easy
answers for a VBA begginer?

Thanks in advance

Similar Threads:

1.Suppress DCOM error when attempting to Read Remote Registry from to read a remote registry


    I need to read the registry of a remote PC (Win2K)

    Any Ideas?


3.User/password credentials on remote registry read(OpenRemoteBaseKe


I've a need to use remote username and password credentials to access remote 
registry information via, can this be done? 

I've currently a vbs script that periodically accesses wmi and registry 
information on remote machines across domains, it uses the 
WbemLocator.ConnectServer facility to provide specific username and password 
credentials. I'm trying to move this code to a vb.Net service and I'm trying 
to avoid the wsh runtime (IWshRuntimeLibrary), which I don't think will run 
in a service environment.

I'm fine using ConnectionOptions to set up a management scope with specific 
usernames/passwords to access WMI information on the remote machines. But is 
there a similar way to use the same username password credentials to access 
remote registry information, preferrebly via the standard OpenRemoteBaseKey 

many thanks for any help,


4.script to read registry keys on remote computers

I have this script that I want to read a registry key from some remote
pcs, same domain.  This script reads the key for the pc it is running
on but what is the syntax to make it move to another pc?



computers = "turbo,turbo2"
computers  = Split(computers ,",")

For x = 0 to UBound(computers)

Set WshShell = WScript.CreateObject("WScript.Shell")
WScript.Echo WshShell.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Network
Associates\TVD\VirusScan Enterprise\CurrentVersion\szEngineVer")


5.Reading a remote registry


I (like a lot of people) need to go out and verify that certain MS patches have 
been installed.  I need to read the registry on 500+ servers to see if the 
latest MS patch was successfully installed.  I have tried several different 
scripts, searched the net and this newsgroup and haven't found a way to search a
remote registry.  I have placed a code snippet below.  Any suggestions will be 
greatly appreciated. 

Thanks in advance, 
Bill Burke 

Sub checkPatch(strComputer) 
  Set WshShell = WScript.CreateObject("WScript.Shell")  
    If KeyExists (strComputer & "\\HKLM\SOFTWARE\Microsoft\Updates _ 
    \Windows 2000\SP5\KB824146") = False Then  
      objTextFile.WriteLine strComputer & ";" & "NOT Patched" 
      WScript.Echo strComputer & vbCrLf & " - Patch Not applied" & vbCrLf 
      objTextFile.WriteLine strCompuer & ";" & "Successfully Patched" 
       On Error Resume Next 
          If Err Then 
             WScript.Echo strComputer & " was not able to delete files." 
          End If 
       On Error GoTo 0 
    End If  
End Sub 

Function KeyExists (key)  
  On Error Resume Next  
  key2 = WSHShell.RegRead (key)  
    If err <> 0 Then  
      KeyExists = False  
      KeyExists = True  
    End if  
End Function  

6. Read remote registry

7. Difficulty reading remote registries - assistance request

8. Help with reading remote registries

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 81 guest