[tinker]

I am sequentially copying items from a data base program to a table in a word
document using a third party macro program. It successfully copies and pastes
about 40 items and then the operation is interupted by this message: "Word
has insufficient memory. You will not be able to undo this action once it is
completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[Graham Mayor]

You want us to modify a third party macro to improve its efficiency without
listing the code?
Your first port of call should be whoever wrote the macro - if that doesn't
help, post the code in the vba forum with details of what it is supposed to
do and maybe someone will pick through it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tinker wrote:
I am sequentially copying items from a data base program to a table
in a word document using a third party macro program. It successfully
copies and pastes about 40 items and then the operation is interupted
by this message: "Word has insufficient memory. You will not be able
to undo this action once it is completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[tinker]

I don't want to change the macro. It works fine. It is Word that is the
problem. The only thing the macro is doing is cutting and pasting. Word's
respone to cutting and pasting would be the same even if I did it manually.
How do I make Word stop generating the nag screen. I do not want the UNDO
function interferring with this process nor do I want to undo anything I have
pasted.
Thank you for any advise you can offer about this Word problem.

"Graham Mayor" wrote:

You want us to modify a third party macro to improve its efficiency without
listing the code?
Your first port of call should be whoever wrote the macro - if that doesn't
help, post the code in the vba forum with details of what it is supposed to
do and maybe someone will pick through it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tinker wrote:
I am sequentially copying items from a data base program to a table
in a word document using a third party macro program. It successfully
copies and pastes about 40 items and then the operation is interupted
by this message: "Word has insufficient memory. You will not be able
to undo this action once it is completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[Pat Garard[_2_]]

Tinker - you are clearly not a thinker.

Any Macro automates Word Functionality.

A badly written Macro may not do this effectively, and/or
may not do this efficiently.

If the Macro is working fine, then you do not have a
problem and you are wasting our time and your own.

However, from your description, the Macro is automating Word
functionality in a way that is INEFFICIENT in terms of memory.

This is a fault in the Macro, and be advised that Graham has probably
passed more Macros down the toilet that you have had hot breakfasts!

You would be well advised to LISTEN to what he has to say,
and you will not achieve this with your mouth OPEN.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

"Tinker" wrote in message
...
I don't want to change the macro. It works fine. It is Word that is the
problem. The only thing the macro is doing is cutting and pasting. Word's
respone to cutting and pasting would be the same even if I did it
manually.
How do I make Word stop generating the nag screen. I do not want the UNDO
function interferring with this process nor do I want to undo anything I
have
pasted.
Thank you for any advise you can offer about this Word problem.

"Graham Mayor" wrote:

You want us to modify a third party macro to improve its efficiency
without
listing the code?
Your first port of call should be whoever wrote the macro - if that
doesn't
help, post the code in the vba forum with details of what it is supposed
to
do and maybe someone will pick through it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tinker wrote:
I am sequentially copying items from a data base program to a table
in a word document using a third party macro program. It successfully
copies and pastes about 40 items and then the operation is interupted
by this message: "Word has insufficient memory. You will not be able
to undo this action once it is completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[tinker]

My, my but arent we defensive today. Defending Micro Soft must be very
stressful. If you have progressed to denial as a method of problem solving
perhaps it is time to explore a different vocation. I guess this sites
contents of 10s of thousands if not 100s of thousands of problems generated
by Word for its customers must be frustrating to deal with. But that is your
problem not mine and please dont project it to me.

Is there anybody at this site that can explain or point to where I can find
out how to clear the undo cache or memory? Clearing the clip board doesnt
seem to help. Closing the file and reopening it does.


"Pat Garard" wrote:

Tinker - you are clearly not a thinker.

Any Macro automates Word Functionality.

A badly written Macro may not do this effectively, and/or
may not do this efficiently.

If the Macro is working fine, then you do not have a
problem and you are wasting our time and your own.

However, from your description, the Macro is automating Word
functionality in a way that is INEFFICIENT in terms of memory.

This is a fault in the Macro, and be advised that Graham has probably
passed more Macros down the toilet that you have had hot breakfasts!

You would be well advised to LISTEN to what he has to say,
and you will not achieve this with your mouth OPEN.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

"Tinker" wrote in message
...
I don't want to change the macro. It works fine. It is Word that is the
problem. The only thing the macro is doing is cutting and pasting. Word's
respone to cutting and pasting would be the same even if I did it
manually.
How do I make Word stop generating the nag screen. I do not want the UNDO
function interferring with this process nor do I want to undo anything I
have
pasted.
Thank you for any advise you can offer about this Word problem.

"Graham Mayor" wrote:

You want us to modify a third party macro to improve its efficiency
without
listing the code?
Your first port of call should be whoever wrote the macro - if that
doesn't
help, post the code in the vba forum with details of what it is supposed
to
do and maybe someone will pick through it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tinker wrote:
I am sequentially copying items from a data base program to a table
in a word document using a third party macro program. It successfully
copies and pastes about 40 items and then the operation is interupted
by this message: "Word has insufficient memory. You will not be able
to undo this action once it is completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[Pat Garard[_2_]]

The Buddhists would advise that problem solving requires a 'Beginners Mind'.

This involves scrutinising everything ... omitting nothing ... no
assumptions.

Practicing Mindfulness (and practicing your smiling), you are cordially
invited to reconsider.

If you would like help - list the Macro.

And, yes, I was defensive - but not of Microsoft.

In these forums we come across '10s of thousands if not 100s of
thousands of problems generated ...' for themselves by obstinate,
ignorant and arrogant persons who ask questions (because they
don't know the answer) and then reject the answer (because
they think they do).

Kindly remember that we work for free, and if we fail YOU ... we
will not be devastated, we just hope that YOU will consider taking
YOUR business elsewhere.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________



"Tinker" wrote in message
...
My, my but arent we defensive today. Defending Micro Soft must be very
stressful. If you have progressed to denial as a method of problem solving
perhaps it is time to explore a different vocation. I guess this sites
contents of 10s of thousands if not 100s of thousands of problems
generated
by Word for its customers must be frustrating to deal with. But that is
your
problem not mine and please dont project it to me.

Is there anybody at this site that can explain or point to where I can
find
out how to clear the undo cache or memory? Clearing the clip board doesnt
seem to help. Closing the file and reopening it does.


"Pat Garard" wrote:

Tinker - you are clearly not a thinker.

Any Macro automates Word Functionality.

A badly written Macro may not do this effectively, and/or
may not do this efficiently.

If the Macro is working fine, then you do not have a
problem and you are wasting our time and your own.

However, from your description, the Macro is automating Word
functionality in a way that is INEFFICIENT in terms of memory.

This is a fault in the Macro, and be advised that Graham has probably
passed more Macros down the toilet that you have had hot breakfasts!

You would be well advised to LISTEN to what he has to say,
and you will not achieve this with your mouth OPEN.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

"Tinker" wrote in message
...
I don't want to change the macro. It works fine. It is Word that is the
problem. The only thing the macro is doing is cutting and pasting.
Word's
respone to cutting and pasting would be the same even if I did it
manually.
How do I make Word stop generating the nag screen. I do not want the
UNDO
function interferring with this process nor do I want to undo anything
I
have
pasted.
Thank you for any advise you can offer about this Word problem.

"Graham Mayor" wrote:

You want us to modify a third party macro to improve its efficiency
without
listing the code?
Your first port of call should be whoever wrote the macro - if that
doesn't
help, post the code in the vba forum with details of what it is
supposed
to
do and maybe someone will pick through it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tinker wrote:
I am sequentially copying items from a data base program to a table
in a word document using a third party macro program. It
successfully
copies and pastes about 40 items and then the operation is
interupted
by this message: "Word has insufficient memory. You will not be able
to undo this action once it is completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[Gordon Bentley-Mix[_2_]]

Tinker,

You're so close to a possible answer and you don't even know it.

"I don't want to change the macro. It works fine."
Mmm... not exactly. It's pretty clear that the problem is the macro and not
Word because (according to you) this problem occurs _only_ when the macro
runs and not when Word is running by itself. Word is only as good at
whatever is driving it.

"The only thing the macro is doing is cutting and pasting. Word's respone
(sic) to cutting and pasting would be the same even if I did it manually."
Again, not exactly. In your original post you said that the problem occurs
after the macro performs around 40 such cut-n-paste operations. I would
imagine that it does this in a matter of moments, and you would struggle to
perform the same number of operations as quickly manually. Time is a factor
in these things, and manual operations are treated differently from
automated ones.

"How do I make Word stop generating the nag screen."
Word is generating this screen for a reason, and the way to make it stop is
to fix the cause of the nag screen. Just suppressing its display is not
enough. If you broke your leg you could be given medication that would stop
the pain but the leg wouldn't be healed, and if you walked on it... I'm sure
you see where this is going.

I can't give you an answer right now for the same reason that Graham didn't
give you one straight away either. I believe that Graham has asked you to
post the code from your third-party macro because he suspects that it is
inefficient but is unwilling to provide specific direction without first
seeing the code, and I agree with his position.

As for Pat Garard's little "rant" your response to it... well... what can I
say? I don't presume to speak for Pat, but we do all get frustrated with
posters from time to time - especially when the poster doesn't recognise the
importance or value of the answer they have been given. When I encounter
these situations I always try to follow Pat's advice and approach the
(secondary) problem with a 'Beginner's Mind' of my own. I ask myself what I
can do to shed sufficient light to allow the poster to see the value in the
answer provided. I can only hope that I have done this here.

So in summary, it would appear that the problem is caused by the third-party
macro. In this instance I would recommend that you contact the vendor of
this macro. If you get no joy through this route, post the code and we'll
see what we can do.
--
Cheers!

Gordon Bentley-Mix
Word MVP

Uninvited email contact will be marked as SPAM and ignored. Please post all
follow-ups to the newsgroup.


"Tinker" wrote in message
...
I don't want to change the macro. It works fine. It is Word that is the
problem. The only thing the macro is doing is cutting and pasting. Word's
respone to cutting and pasting would be the same even if I did it
manually.
How do I make Word stop generating the nag screen. I do not want the UNDO
function interferring with this process nor do I want to undo anything I
have
pasted.
Thank you for any advise you can offer about this Word problem.

"Graham Mayor" wrote:

You want us to modify a third party macro to improve its efficiency
without
listing the code?
Your first port of call should be whoever wrote the macro - if that
doesn't
help, post the code in the vba forum with details of what it is supposed
to
do and maybe someone will pick through it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tinker wrote:
I am sequentially copying items from a data base program to a table
in a word document using a third party macro program. It successfully
copies and pastes about 40 items and then the operation is interupted
by this message: "Word has insufficient memory. You will not be able
to undo this action once it is completed. Do you want to continue?"

Is there a way to prevent word from collecting the items in memory?
Is there a way to increase the memory so there is no conflict?
Is there a way to make word overwrite memory items without asking?

Office Proffessional 2003/Windows XP/1.5g Ram

[tinker]

Gordon: Thank you for your considerate thoughtful response. It is likely that
I would have worked through this problem in a different manner had you been
the one to initiate the process. It was refreshing after enduring the load of
pretentious bull dodo from Pat. Life is much too short to put up with pompous
fools. The irony of accusing me of his own faults is lost on him. He is so
busy talking that he is incapable of listening. I guess sitting cross legged
on his Australian mountain dressed in Khaki waiting for supplicants to arrive
begging for code must be exhausting. It is appropriate that he works for
free. Any other remuneration would be an over charge.

I provided too much information. €œThird Party Macro€� obviously was a red
flag to three purists. I ask for a Volkswagon and you insist I must have a
Lamborghini.

Question: €œIs there anybody at this site that can explain or point to where
I can find out how to clear the undo cache or memory?€�

Answer:
Sub ClearUNDOcache()
ActiveDocument.UndoClear
End Sub

This will run prior to a swack of copy and pastes.

I know this will irk but I have the third party macro running the above Word
Macro. I really dont care if it wastes Word resources or that it is not
pretty or that a purist would not approve or that three MVPs will sniff. It
works and I will not have to be subjected to any more abuse/advise. In a
perverse way Pat can claim credit for inspiring the research needed to locate
the solution.

[tinker]

Gordon: Thank you for your considerate thoughtful response. It is likely that
I would have worked through this problem in a different manner had you been
the one to initiate the process. It was refreshing after enduring the load of
pretentious bull dodo from Pat. Life is much too short to put up with pompous
fools. The irony of accusing me of his own faults is lost on him. He is so
busy talking that he is incapable of listening. I guess sitting cross legged
on his Australian mountain dressed in Khaki waiting for supplicants to arrive
begging for code must be exhausting. It is appropriate that he works for
free. Any other remuneration would be an over charge.

I provided too much information. €œThird Party Macro€� obviously was a red
flag to three purists. I ask for a Volkswagon and you insist I must have a
Lamborghini.

Question: €œIs there anybody at this site that can explain or point to where
I can find out how to clear the undo cache or memory?€�

Answer:
Sub ClearUNDOcache()
ActiveDocument.UndoClear
End Sub

The above will run prior to large number of copy/paste operations.
I know this will irk but I have the third party macro running the above Word
Macro. I really dont care if it wastes Word resources or that it is not
pretty or that a purist would not approve or that three MVPs will sniff. It
works and I will not have to be subjected to any more abuse/advise. In a
perverse way Pat can claim credit for inspiring the research needed to locate
the solution.