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

Michael,

Someone else has already solved this problem for us:

http://www.appspro.com/Utilities/CodeCleaner.htm

Tim


"MichaelDavid" wrote in message
...
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

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


"Tim Williams" wrote:

Michael,

Someone else has already solved this problem for us:

http://www.appspro.com/Utilities/CodeCleaner.htm

Tim


"MichaelDavid" wrote in message
...
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


.

How could Rob Bovey merely be "someone else" <g

Regards,
Peter T

"Tim Williams" wrote in message
...
Michael,

Someone else has already solved this problem for us:

http://www.appspro.com/Utilities/CodeCleaner.htm

Tim


"MichaelDavid" wrote in message
...
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