SaveSetting: Excel 2000 & 2003
 

With Excel 2000, SaveSetting stores at:
HKCU\Software\VB and VBA Settings\
What key does Excel2003 use? On my Pc, it seems to store at
HKEY_USERS\{a guid}\software\VB and VBA Settings\
Why?
Thanks for any insight.

SaveSetting: Excel 2000 & 2003
 

I just tried the following in Excel 2003

SaveSetting "TestApp", "General", "TheKey", "KeyValue"

and it saved the value to both

HKCU\Software\VB and VBA Program Settings\TestApp\General

HKEY_USERS\S-1-5-21-527237240-484763869-725345543-1003\Software\VB
and VBA Program Settings\TestApp\General


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"AA2e72E" wrote in message
...
With Excel 2000, SaveSetting stores at:
HKCU\Software\VB and VBA Settings\
What key does Excel2003 use? On my Pc, it seems to store at
HKEY_USERS\{a guid}\software\VB and VBA Settings\
Why?
Thanks for any insight.

SaveSetting: Excel 2000 & 2003
 

Chip, thanks for looking into it. With 2003, I do not see any entries at HKCU
and with 2000 I see entries only at HKCU. There must be some configuration
option that dictates the target node.

"Chip Pearson" wrote:

I just tried the following in Excel 2003

SaveSetting "TestApp", "General", "TheKey", "KeyValue"

and it saved the value to both

HKCU\Software\VB and VBA Program Settings\TestApp\General

HKEY_USERS\S-1-5-21-527237240-484763869-725345543-1003\Software\VB
and VBA Program Settings\TestApp\General


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"AA2e72E" wrote in message
...
With Excel 2000, SaveSetting stores at:
HKCU\Software\VB and VBA Settings\
What key does Excel2003 use? On my Pc, it seems to store at
HKEY_USERS\{a guid}\software\VB and VBA Settings\
Why?
Thanks for any insight.