Frank,
You can use INI files or the system registry to save settings
from one session to the next. For example, you can store the
position of a form when it is closed and then display the form in
the same position the next time it is displayed. If the settings
are stored in an INI file or the registry, they will be saved
even if the user exits Excel (or the VB6 program) between uses.
INI files are considered a dated, if not obsolete, approach, and
the generally preferred way is to save settings in the system
registry instead. You can use the GetSetting and SaveSetting VBA
functions to read and write values to the registry.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Frank" wrote in message
...
Can some body tell me if there any benefit in using INI
file with excel applications, I read a mag where it said
that using INI files to hold items for forms and
formatting. Has any body here used them I can understand
using them with VB6 etc etc any feedback will be much
appreciated .
Frank