Hello

I have check all the forums but couldn't find anything. I don't even know if it's possible, i'm a beginner in VBA

The idea is that i have many documents with the same structure, each time I do a change on a 1 document I record a macro to be able to apply it to the other documents to keep always the same structure. But I'm not the one who is going to open the other files, and there are many files to update, so i want that the incremental macro(s) to be ran automatically when the user open a document, so I'm sure his file is updated according to the last macros I did.

For example :
I update my file and record the change in a first macro on monday that I call "20130716" (the date of the change)
Then a second change, new macro : "20130720"
Then 3rd : "20130722"
and so on

The other user open a file that need to be updated, he doesn't know anything in macro so it has to be automatic. I cannot open his file and apply the change automatically as the file might be already in use and in read only :/

My idea :
When a macro is run, then the last update date is changed in a cell of the file
Then it opens a shared excel file where all the macros are recorded and named in a column
Then we would run one by one (in the correct order) the other macros available from the last update using the names of macros in the shared excel file, except the ones already ran previously. So maybe we should be able to call a macro which name is in a cell (Is it possible?) ?The same macro should not be ran twice of course.

But I have absolutely no idea on how to do that !

Do you think it's possible ? Any idea ? Maybe an other solution for this problem ?

Thanks so much if you can help me

Antoine