Re: Best way to use INI file

I would read the entire INI file at startup, store the values somewhere, and
then write back the entire INI file at shutdown.

As an aside, INI files were supposed to be made obsolete by the System
Registry. Is there any particular reason you are using an INI file rather
than GetSettings and SaveSetting to store data in the registry.

Moreover, why not just save the settings in the add-in itself?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"M. Authement" <mautheme@xxxxxxx> wrote in message
news:%23d1EcswFHHA.1080@xxxxxxxxxxxxxxxxxxxxxxx
I am developing an add-in and am using an INI file to store various options
and lists. My question is this: am I better off reading the INI file into
a work*** as part of the Workbook_Open event (and therefore having only 1
call to the INI file) or just call the INI file as needed? I have a class
module that defines all of the INI reads/writes, so the code is no problem.
Just wondering if there are advantages/disadvantages to the two methods.
TIA.


Using WinXP and XL2003.



.