Will using a "personal macro workbook" slow down my other VBA code

S

Stacymm

I have a several VBA procedures that read and process large (+50M) data
files. I am trying to do everything I can to optimize the speed.

Up until now, I was unfamiliar with "personal macro workbook". I would like
to use it for some of the macros that I use daily, but are stored in
individual workbooks.

If I starting using the "personal macro workbook", when I process my my
files, will it slow my programs down even more?

I currently am using Excel 2003. Thanks in advance
 
M

Mike Fogleman

Where the macros reside when they are run should make no difference in their
speed. How you write the macros will effect speed by avoiding selections,
screen updating, re-calculations, be aware of alerts and error handling,
etc.

Mike F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top