View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
syswizard syswizard is offline
external usenet poster
 
Posts: 23
Default Storing important values: ini file, XML, Registry, where else ?

For small amounts of data, there seems to be several ways to store
important values and parameters used in an Excel application.
I've always thought that using the ini file approach is the best, but
there are no built-in functions in Excel to read and write this data.
XML seems too verbose and again, there are no XML parsers built into
Excel.
Storing values in the Windows registry seems like one of the best
alternatives.

Anyone have comments on the above ? Obviously using a database like
Access or MySQL is one other alternative, but it seems like it would
be overkill for maintaining a small set of data.

TIA.