Word has insufficient memory to complete this operation

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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.

 

[Pat Garard]

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.

 

[Tinker]

My, my but aren’t 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 site’s
contents of 10’s of thousands if not 100’s of thousands of problems generated
by Word for it’s customers must be frustrating to deal with. But that is your
problem not mine and please don’t 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 doesn’t
seem to help. Closing the file and reopening it does.

 

[Pat Garard]

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 '10’s of thousands if not 100’s 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
_______________________

 

[Gordon Bentley-Mix]

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]

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 don’t care if it wastes Word resources or that it is not
pretty or that a purist would not approve or that three MVP’s 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 don’t care if it wastes Word resources or that it is not
pretty or that a purist would not approve or that three MVP’s 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.

 

[Pat Garard]

G'Day (again) Tinker,
After sitting cross-legged all this time, I need to stretch my legs, take a
pee and change my Khakis.

... In a
perverse way Pat can claim credit for inspiring the research needed to
locate the solution.

Diplomacy is the art of letting someone else get your way.
-Unknown

I provided too much information. “Third Party Macro†obviously was a red
flag to three purists. I ask for a Volkswagon (sic) and you insist I must
have a Lamborghini.

Expert: Avoids the small errors while sweeping on to the grand fallacy.
-Unknown

... 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.

The worst of all deceptions is self-deception.
-Plato

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

My God, but you SUCK ...

Now I really must get back to my meditation ... and my supplicants!
Consider: http://letsbefriends.blogspot.com/
--
Regards,
Pat Garard
Melbourne, Australia
_______________________
Mistakes live in the neighbourhood of truth and therefore delude us.
-Rabindranath Tagore

 

[Tinker]

G’Day Pat: A walk-about sounds like a good idea. Take deep breaths. I
understand it helps with stress or anger. I am glad to see your sense of
humour remains undamaged. Personally I use the lashing out method. I’m a
healthy carrier.

Now I really must get back to my meditation ... and my supplicants!
Consider: http://letsbefriends.blogspot.com/

Will I be the frog or the mouse?

Consider: http://www.minsky.net/Tire swing cartoon.jpg
There are many roads to Rome. My road also gets me there safe.

If you are going to critique you should critique all. (Supplicant at the
mountain)

Sub ClearUNDOcache()
ActiveDocument.UndoClear
End Sub

Is there more code I should be aware of? It results when run (by itself with
no interaction with the despised third party macro), a rather wonky response
to CTRL Z the Undo command. I do not need to know the answer because I don’t
intend to UNDO anything but others may.

IE: After Macro is run and CTRL Z activated sometimes auto correct does not
work and everything typed after macro is UNDONE at once and it works normal
if you insert text prior to the point where the macro was run.