Hey Guys
I have made a report-system that collects som summaries from a set of
users. In each local user Excel-file there is a macro that does stuff.
Sometimes I have to update this "local" macro - and have to ask every
user to replace the macro update manually (copy/paste in VBA).
Its not that big effort, but it would be more "proffessional"
expression if I could send over an automatic update sort-of-macro by
mail.

The update macro
1) I -as administrator - will chose the name of the macro to be
updated
2) I send thr update to the user
2) The user chose the local receiving file from the explorer/open-file
manager
3) My macro updates the local macro by running this update macro

Is this possible and how do I do it?

Example

Local file Report.xlsm contains a macro UpdatePivotFields
__________________
Best Regards
Snoopy