Does it slow a document down if I put its VBA code in another File?

[tonywatsonhelp]

Hi Everyone,

I have a situation where I currently have 25 stores all with exactly the same very complex document.

now the problems I face are that if I need to update a macro for example, I have to go into every copy and change it.

So I was wondering if it would slow the document down if I pulled the VBA out of the document into an unsed document that just stored its VBA, that why i could just update once and copy and paste the document into the 25 folders saving me a lot of time.

can this be done? is it a good idea?

thanks

Tony

 

[MARK858]

The actual coding would take microseconds so no but what you put in the coding could slow it down.

 

[dmt32]

Hi,
sounds like you could create an Addin for users to install which maybe be easier to update.

have a read here:http://www.ozgrid.com/VBA/excel-add-in-create.htm

and see if any help


Dave