Greetings,
I want to distribute a UDF to several users on different work stations. i'm
looking for a very simple process from the users' point of view. I thought
maybe a good way of doing this would be to send them a file with a macro that
writes the UDF to their personal.xls
If this possible, how would I proceed?
Is there a better way?
TIA
--
David

Hi David,

You should endeavour to avoid changing other people's Personal.xls files.

You could send the UDF as a text email with instructions on adding the
function to the user's Personal.xls.

You may also wish to visit Jan Karel Pieterse's site:

http://www.jkp-ads.com/Articles/DistributeMacro02.htm



---
Regards,
Norman



"David" wrote in message
...
Greetings,
I want to distribute a UDF to several users on different work stations.
i'm
looking for a very simple process from the users' point of view. I thought
maybe a good way of doing this would be to send them a file with a macro
that
writes the UDF to their personal.xls
If this possible, how would I proceed?
Is there a better way?
TIA
--
David

If the users are all on the same network, I recommend putting a single copy
of the UDF into an Add-In (per the Jan Karel's instructions) located on the
network. When the the users activate the Add-In on their machine, they
should decline Excel's offer to copy it to their library directory. That
will greatly simplify maintenance, since they will all be accessing the
Add-In from a common location instead of owning separate copies of it.

Jerry

"Norman Jones" wrote:

Hi David,

You should endeavour to avoid changing other people's Personal.xls files.

You could send the UDF as a text email with instructions on adding the
function to the user's Personal.xls.

You may also wish to visit Jan Karel Pieterse's site:

http://www.jkp-ads.com/Articles/DistributeMacro02.htm



---
Regards,
Norman



"David" wrote in message
...
Greetings,
I want to distribute a UDF to several users on different work stations.
i'm
looking for a very simple process from the users' point of view. I thought
maybe a good way of doing this would be to send them a file with a macro
that
writes the UDF to their personal.xls
If this possible, how would I proceed?
Is there a better way?
TIA
--
David

Thanks Jerry and Norman,
Your words of wisdom are appreciated

"Jerry W. Lewis" wrote:

If the users are all on the same network, I recommend putting a single copy
of the UDF into an Add-In (per the Jan Karel's instructions) located on the
network. When the the users activate the Add-In on their machine, they
should decline Excel's offer to copy it to their library directory. That
will greatly simplify maintenance, since they will all be accessing the
Add-In from a common location instead of owning separate copies of it.

Jerry

"Norman Jones" wrote:

Hi David,

You should endeavour to avoid changing other people's Personal.xls files.

You could send the UDF as a text email with instructions on adding the
function to the user's Personal.xls.

You may also wish to visit Jan Karel Pieterse's site:

http://www.jkp-ads.com/Articles/DistributeMacro02.htm



---
Regards,
Norman



"David" wrote in message
...
Greetings,
I want to distribute a UDF to several users on different work stations.
i'm
looking for a very simple process from the users' point of view. I thought
maybe a good way of doing this would be to send them a file with a macro
that
writes the UDF to their personal.xls
If this possible, how would I proceed?
Is there a better way?
TIA
--
David