I have a registry key for a 3rd party application located under
HKEY_LOCAL_MACHINE but I cannot hardcode the key since all I know of
the registry key is HYP in different versions the path is different is
there a simple way of searching the registry for the path of this key
and then find the value in this key.

Thanks
Belinda

Hi Belinda,

I think you can do that with VB's GetSetting command if
you are using Excel 97 or later. Try this handy link...

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

-----Original Message-----
I have a registry key for a 3rd party application located
under
HKEY_LOCAL_MACHINE but I cannot hardcode the key since
all I know of
the registry key is HYP in different versions the path is
different is
there a simple way of searching the registry for the path
of this key
and then find the value in this key.

Thanks
Belinda
.

GetSetting, as with SaveSetting, only works within a very limited part of
the registry, namely HKEY_CURRENT_USER\Software\VB and VBA Program Settings,
and so is useless for more general registry access.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Serkan Gur" wrote in message
...
Hi Belinda,

I think you can do that with VB's GetSetting command if
you are using Excel 97 or later. Try this handy link...

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

-----Original Message-----
I have a registry key for a 3rd party application located
under
HKEY_LOCAL_MACHINE but I cannot hardcode the key since
all I know of
the registry key is HYP in different versions the path is
different is
there a simple way of searching the registry for the path
of this key
and then find the value in this key.

Thanks
Belinda
.