On Jan 26, 11:33*am, Snoopy wrote:
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

Have you considered putting all of the 'local' code into a single add-
in which is available to all. When changes are required simply reissue
the updated add-in to all of your users i.e. replace the whole file
rather than getting your users to cut/paste individual lines of code -
their workbooks remain untouched as long as the reissued add-in has
the same name as the previous version.

A.