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

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

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

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


"William Benson" wrote:

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

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

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


"JT" wrote in message
...
Yes it does. We set a Reflection session to upload information.
Reflection
is the program used to access our legacy programs.
--
JT


"William Benson" wrote:

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

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

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

"JT" wrote in message
...
Yes it does. We set a Reflection session to upload information.
Reflection
is the program used to access our legacy programs.
--
JT


"William Benson" wrote:

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

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

Not that I know of.
--
JT


"Ed" wrote:

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

"JT" wrote in message
...
Yes it does. We set a Reflection session to upload information.
Reflection
is the program used to access our legacy programs.
--
JT


"William Benson" wrote:

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

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

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

"JT" wrote in message
...
Not that I know of.
--
JT


"Ed" wrote:

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

"JT" wrote in message
...
Yes it does. We set a Reflection session to upload information.
Reflection
is the program used to access our legacy programs.
--
JT


"William Benson" wrote:

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

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