Hi,

One of my add-ins uses an ini file to control how things run. This
enables me to update certain values which are available to all users
without having to update the add in everytime. The add-in is used by
many different people, so the ini file is stored on a network drive.
The ini file location is stored as a constant within the add-in and
everything works fine.

This add in now needs to be deployed to different sites, all of which
have a different network set up. What I'd like is for the user to be
prompted to select the location of the ini file during installation,
and have the add-in remember the path for future use.

Theres probably a few different options, and i'd appreciate as many
ideas as possible. Some of our PCs are heavily locked down so options
such as writing to the registry or creating a local file may or may not
be possible. The ideal is for the value to be stored somehow within
the add-in. Possible?

Many TIA,

Red.

Hi Red,

The ideal is for the value to be stored somehow within
the add-in. Possible?

I guess the simplest thing to do would be to write the info to a
worksheet in the addin and save the addin itself after a change of
settings. (That is, if you are not planning to have a single addin on a
central location)

An alternative might be to create an extra folder in the documents and
settings folder of the user. Chances are good that everyone has
read/write permissions to that location. Otherwise, also the My
Documents folder should be open to read/write access, so maybe adding a
folder there might help.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Isn't the logical thing to store the ini file in the same location as the
addin, then the addin can use its own directory path. You must be able to
write to that directory, else you don't even get started.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Red" wrote in message
oups.com...
Hi,

One of my add-ins uses an ini file to control how things run. This
enables me to update certain values which are available to all users
without having to update the add in everytime. The add-in is used by
many different people, so the ini file is stored on a network drive.
The ini file location is stored as a constant within the add-in and
everything works fine.

This add in now needs to be deployed to different sites, all of which
have a different network set up. What I'd like is for the user to be
prompted to select the location of the ini file during installation,
and have the add-in remember the path for future use.

Theres probably a few different options, and i'd appreciate as many
ideas as possible. Some of our PCs are heavily locked down so options
such as writing to the registry or creating a local file may or may not
be possible. The ideal is for the value to be stored somehow within
the add-in. Possible?

Many TIA,

Red.