update vba code in multiple files

[opinion]

hello there
i have a problem
i create a excel file with vba code that is doing osme jobs on some files. copies of this excel file are used by several peoples and are saved with differnet names (but there are some rules applies for name).
my question is: when i do updates on my master file (in vba code) - how can i deploy the changes to all files of same type? it will be usefull something like the "slave" file sto check on open if the master (stored in a known location) has been changed (only the vba code)
thanks in advance

[venkat1926]

not fully clear.

however you can park the macro in personal.xls

in the macro instead of particular workbook(file) name you use activeworkbook

some such changes may be necessary

[opinion]

not fully clear.

however you can park the macro in personal.xls

in the macro instead of particular workbook(file) name you use activeworkbook

some such changes may be necessary

let me explain my needs in another way:
so i have the file master.xls where i edit and create maybe new features. the scope of this file is quite simple, is using the folder tree described below:
- parent folder

scn

res_tested_part

res

ok

nok

in the scn folder i have some test scripts, after i run the script in other sw i put the results in res_tested_part folder and after that i evaluate the response and i move test results that are ok inthe OK folder and the rest of them in the nok folder.
other people are using the same excel file but with other set of test files and corresponding results.

my need is when i update/develop something new/correct a bug to have the possibility to deploy somehow in automatic way this to all excel files of this type (updating the vba code without copy save the new excel file)

i hope that i managed to explain better my need this time

thank you