a new error message

[Guest]

I have used a macro every day for months without any problems until last
week. Now I am able to run it one time and then I receive this message when
I attempt to use it again.

"Microsoft Office Excel is waiting for another application to complete an
OLE action."

Any suggestions on how to correct this issue would be appreciated. Thanks
for the help.............JT

 

[William Benson]

Does the macro bring in or access any Objects (Word, Powerpoint, PDFs?)

 

[Guest]

Yes it does. We set a Reflection session to upload information. Reflection
is the program used to access our legacy programs.

 

[William Benson]

I hope someone jumps on this, I only asked because I have seen similar
behavior from Excel when dealing with PDF files.

 

[Ed]

JT - Does this have anything to do with HP and TIRs?
Ed

 

[Guest]

Not that I know of.
--
JT

JT - Does this have anything to do with HP and TIRs?
Ed

 

[Ed]

Just wondering of it might be part of the same system we use a program
called "Reflection" for.

Just general thoughts: you're activating Reflection to access a legacy
program to get info into Excel. That's a long line, and can be pinched at
several points. It sounds like something has slowed the works down, and the
process is taking longer than it did before. If something is slowing the
data transfer between Reflection and the other program, your macro might
hang. If Reflection is in the middle of transferring the data to Excel, you
might hang. Is either Reflection or your legacy program timing out? Did
someone else schedule a process at the same time as yours, overloading
system resources?

Also, make sure your objects are Set to Nothing and properly terminated.
The next time this hangs, you might pull up the Task Manager and what
process is still out there besides Excel.

Good luck!
Ed