Best Way to Read the Registry?

[JK]

My application must read the registry and confirm the presence of a value.

So I turned to John W's syntex. Unfortunately, he doesn't give an
"If...Else...End If" example to read the registry. In any case, the syntex
works when the value is present. However, I am using an error handler to
tell me when the value is NOT present. Is this correct? Or can someone
suggest an "If...Else...End If" procedure that wouldn't require the use of
an error handler.

Thank you in advance.

Jim Kobzeff

 

[Dave Peterson]

Are you refering to John Walkenbach's tip from:

http://j-walk.com/ss/excel/tips/tip60.htm

If yes, then notice these two lines:

' Get setting from registry
Counter = GetSetting("XYZ Corp", "Budget", "Count", 0)
LastOpen = GetSetting("XYZ Corp", "Budget", "Opened", "")


The last parm passed to the GetSetting is the default value if that key hasn't
been set. See VBA's help for more info.

In this example, if Counter wasn't found, it'll be 0. If LastOpen wasn't found,
it'll be "".

 

[Ron de Bruin]

Hi JK

Maybe you can use this
http://www.rondebruin.nl/register.htm

 

[JK]

Thank you Ron and Dave.