I would create a class object and read the INI file and store as properties
of the class.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"M. Authement" wrote in message
...
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 worksheet 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.