Take a look at almost any .INI file

You'll see that there are keys like:
[Mail]
MAPI=1
CMCDLLNAME32=mapi32.dll
CMCDLLNAME=mapi.dll
CMC=1
MAPIX=1
MAPIXVER=1.0.0.1

(from my Win.INI file)

If you layout the record the same way, you could read each record and parse it
out.

or...

A little search of google will give you lots of hits:

http://groups.google.co.uk/group/mic...63099721c94c8e

or

http://snipurl.com/f0iz

TimE wrote:

Thank you Dave, it worked. If you have a spare minute, can you help me
with something else or point me in the right direction?

I would like to expand the preference file to more than one value and
of course be able to read the value when the spreadsheet is opened.

The problem I am facing is how to include what the value is for and
then how to "find" it again.

--
TimE
------------------------------------------------------------------------
TimE's Profile: http://www.excelforum.com/member.php...fo&userid=2139
View this thread: http://www.excelforum.com/showthread...hreadid=512397

--

Dave Peterson