LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 213
Default Loop, reading registry settings

In the code below I have many "Keys" that will share the same value as the
"Setting" in the Registry.
Example:
ADMCustomerList (Appname), Customers (Section), Number1 (Key), Number1
(Setting).
What I see happening is I am retrieving both "Section" and "Key" values but
I do not know how to separate them in my code.

The variable "sCustomer" is used like "sCustomer(0, 1)" which would report
the first item in the list, "0" is the "Section" and "1" is the "Key". A "0"
should skip the "Section" value and the following numeric value is the
corrosponding "Key" value location, IE, 1 thru 10 or 1 thru some number.

How can I read only the"Key" values?

'===========
With ListBox1
Dim c As Variant
Dim sCustomer As Variant, intSettings As Integer
sCustomer = GetAllSettings(appname:="ADMCustomerList", section:="Customers")
For intSettings = LBound(sCustomer, 1) To UBound(sCustomer, 1)
Debug.Print sCustomer(intSettings, 0), sCustomer(intSettings, 1)
Next intSettings
For Each c In sCustomer
..AddItem c
Next
End With
'=============
--
Regards

Rick
XP Pro
Office 2007

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading registry with Excel Alesandro Senerchia Excel Programming 1 April 26th 05 07:53 AM
Reading registry with Excel Alesandro Senerchia Excel Programming 1 April 26th 05 12:26 AM
Reading the Registry JK Excel Programming 1 March 6th 05 09:42 AM
Excel Registry Add in settings R Avery Excel Programming 3 May 25th 04 07:12 PM
Reading the Registry - CSV Download Flag Tim Childs[_6_] Excel Programming 6 December 10th 03 10:39 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"