Does a workbook become fragmented after much editing?


M

MichaelDavid

Greetings! I have been reading "ExcelTips: The Macros, Fifth edition"
published by:
Sharon Parq Associates, Inc., PO Box 794, Orem, UT 84059. On p 23, it states
the following:

"As you make changes to macros, adding and removing code, the actual file
used to store the macros (the workbook) can get quite fragmented. It seems
that internally the macros are stored in blocks, and much like a disk drive,
the blocks can become “non-contiguous†over time. (This happens only through
editing, not through use of the macros themselves.) Some readers have
reported that there are times the fragmentation can get so bad that the
macros may fail or the workbook become unusable.
The solution to this potential problem is to do your macro development in a
different workbook than the one that will eventually hold the macros. Thus,
when the macro is transferred to its final home, it will be transferred as a
contiguous block, rather than being fragmented.
If you want to make sure that the macro fragmentation is completely removed
from a current workbook, all you need to do is export your VBA modules to
text files, create a brand new workbook, and import the modules into it."

Is this true of Excel VBA 2007? Since I have 200 Excel VBA Macros in my
Personal Workbook, it would be considerable work to export my VBA modules to
text files, create a brand new workbook, and import the modules into it.
Perhaps, if it is necessary to defrag the Personal Workbook, there is a
quicker way to accomplish this. I welcome all your comments and suggestions.
May you have a blessed day.
--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick
 
Ad

Advertisements

M

MichaelDavid

Hi Tim:
I downloaded and ran your recommendation. I then ran some of my macros.
They seemed to run ok, hopefully faster. Thanks for your help.
--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick
 
Ad

Advertisements


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