Saving in Bits

[Geoff]

I noticed, when looking at someone else's VBa project recently, that instead of saving all forms, modules etc as a single .dot file he had them saved individually (quite a list of .frm, .frx and .bas files) and, presumably, loaded them in as required when a new document was started based on the template. I guess it would all be managed from Auto_New in ThisDocument.

Why is this done?

And, if it is a good idea, how is it done?

TIA

Geoff

[macropod]

Hi Geoff,

Other than perhaps making it easier to replace individual modules without having to open the document to edit it, I can't see any particular advantage. The disadvantage is that you'll then need extra code to load the various modules - and this can become a fairly complex logic exercise if they're only to be loaded 'as required'. There's also a greater risk of the whole process falling over if a stand-alone module is edited/moved/deleted.

[Geoff]

Many thanks.

I can stick that in the "too difficult" drawer then, along with classes :-)

Geoff