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
.