Scripting

Hopefully this will help you:

Const HKEY_CURRENT_USER = &H80000001
strComputer = "."

Set objRegistry=GetObject("winmgmts:\\" & _
strComputer & "\root\default:StdRegProv")

strKeyPath = "Software\Test"
strValueName = "Sample Value 1"
objRegistry.DeleteValue HKEY_CURRENT_USER, strKeyPath, strValueName

Also got to this website and download the archives... Very handy for reference:
http://www.microsoft.com/technet/scriptcenter/resources/qanda/hsgarch.mspx

Thank u for ur reply.

I used this script but it is deleting the Open (Stringvalue). But I want to delete only data in Open.ie,.C:\ProgramFiles\Panopticon\abc.xla

Name Type Data
Open REZ_SZ C:\ProgramFiles\Panopticon\abc.xla

Could U just give me the solution for this.

No, no, no, no, NO! NEVER use the 'Open' value when dealing with XL add-ins, and you should certainly avoid hard-coded Office versions in script. Use XL's Automation to add and remove its add-ins. Search *this* forum for 'Excel' and 'add-in' and you'll find examples. Or, if all else fails, there's a search thingy called 'Google' which is proving quiote popular these days.

Now, what on earth does this:
ORIGINAL: sanhivi
Name Type Data
Open REZ_SZ C:\ProgramFiles\Panopticon\abc.xla mean? That isn't a script. What is it?

Also, why on earth do you want to remove only the data in that entry? I could understand if you wanted to replace it. If you leave it there with no data and the user subsequently adds another add-in, XL is going to become confused, as will the user when he opens the add-ins menu and sees a blank entry in his list of available add-ins.

Hi we can also do this way. Import the registry key you wanted to delete and save it as xyz.reg and edit the the registry key by adding '-' for example
[-HKEY_CURRENT_USER\Software\xyz]

add command

regedit.exe /s xyz.reg

Does the work for you.

Regards,
Ram.

ORIGINAL: Ram
Does the work for you. ...yeh, except it's not the work which the OP wants. Your method deletes the entire key, whereas the OP wants (for some bizarre reason) to remove the entry's data.

Hi,
try this....

use wise script editor
go to edit registry
Add a registry key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Active Setup\Installed Components
create a new stubpath
and create a new value
reg.exe delete "HKCU REGISTRY PATH" /v /F

...which, just like the previous example, deletes the value. The OP wants - for reasons I am unable to fathom - to delete the value's data.

Set Sh = CreateObject("WScript.Shell")
key = "HKEY_CURRENT_USER\"
Sh.RegWrite key & "Software\Microsoft\Office\11.0\Excel\Options\Open", ""

Try the above one. is this are you looking for ...

Set Sh = CreateObject("WScript.Shell")
key = "HKEY_CURRENT_USER\"
Sh.RegWrite key & "Software\Microsoft\Office\11.0\Excel\Options\Open", "" Again, a hard-coded Office version number (BAD idea) and an assumption that the add-in is in the first position (add-ins are referenced as 'Open' for the first, 'Open1' for the second, 'Open2' for the third and so on.

Hi,
don't know if you have already a solution.
The simpliest way is to use REG ADD in the following way.

REG ADD "HKCU\Software\Microsoft\Office\11.0\Excel\Options" /V "Open1" /T REG_SZ /F

So the existing entry will be overwritten with an empty value.

REG ADD "HKCU\Software\Microsoft\Office\11.0\Excel\Options" /V "Open1" /T REG_SZ /F Aaaaaaaaaaand, yet again, a hard-coded Office version number (BAD idea) and an assumption that the add-in is in the first position (add-ins are referenced as 'Open' for the first, 'Open1' for the second, 'Open2' for the third and so on. )