SaveSetting: Excel 2000 & 2003

A

AA2e72E

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.
 
C

Chip Pearson

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
 
A

AA2e72E

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top