Can I update my ThisWorkbook Module from within the module itself?

[TheRedCardinal]

I have a set up like this:

• 1 Central Maintained Control Spreadsheet
• Several (10+) specific and customised Workbook

When the customised workbooks open, they delete 3 VBA modules (Command, Command and Security) and re-import the latest modules from a centralised repository. They are saved as .bas files there. It works great.

The update comes from a Workbook_Open sub in the ThisWorkbook module.

Now I went to update the ThisWorkbook subs centrally as well. I have a ThisWorkbook .cls file in the same central repository.

But I'm running into problems with basically trying to update the ThisWorkbook subs from a sub contained therein.

Is there a way to do this from within the ThisWorkbook Open_Sub routine (there are other routines to import as well), or do I need to write a new workbook which basically pushes the update out to the files?

 

[Logit]

There may be other methods of accomplishing your goal ... but for what it is worth ... as an experiment in personal learning, I did change a macro in
another workbook. So to answer your question "push the updated macro out to the files" ... that would be yes.

Our you might consider simply replacing the entire workbook with a new workbook that includes the needed data. The new workbook would have
the updated macro within.

 

[TheRedCardinal]

Thanks @Logit

I can replace the workbooks but as I'd need to do them one by one this is not a good plan. I was hoping for a single button solution, or to imbed it into the workbook itself.

I will work on the "push" solution for now.