Speed and size

[Mollethewizard]

Hello all gurus out there!

Can anyone tell me what is the most efficient regarding speed and size – one module with all subs in it or many modules with one or a few subs? Somewhere along the line I’ve heard that speed increases when VBA doesn’t need to resolve dots.

All the subs that I use frequently I’ve saved in a module called HM. Every time I need to make a CALL VBA has to resolve the dot (Call HM.Persnr e.g.) is this very speed limiting?

And finally document-size. Is the document going to be smaller when you have fewer modules in your VBA-project?

Christer

 

[Loomah]

Hi
I can't answer your question fully but I can confirm the idea that the number of 'dots' slow processing - although I've never done anything that I've noticed this with!

eg
MsgBox Range("a1")
&
MsgBox Application.ThisWorkbook.ActiveSheet.Range("A1").Value
both give the same result but the former is supposed to be the quicker option. Certainly quiker to type!

Personally, if were to have more than 1 module I'd try to group routines that may rely on each other.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244