what is an OLE action

[funkymonkUK]

HI

I have a workbook which has a macro which exports data from a user t
myself by attaching a file to an email. However the user has receive
an error "Microsoft Office excel is waiting for another aplication t
complete an OLE action." What is an OLE action.

Could anybody suggest an answer? Many Thank

 

[Chip Pearson]

OLE stands for "Object Linking and Embedding", which is the
mechanism or plumbing that lets you put, for example, a Word
document or a command button, on an Excel worksheet. Excl issues
commands to the OLE object, and waits for a reply back from the
OLE object indicate that the command is completed, or at least
that the OLE object received the command. The message "Microsoft
Office excel is waiting for another application to complete an
OLE action." means that the OLE object hasn't replied back to
Excel within the timeout threshold.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"funkymonkUK"
in message
news:[email protected]...

 

[funkymonkUK]

Thanks for the explaination. What I found was the user was using Outlook
XP which has a feature of warning users that other software is trying to
send email and they can allow or disallow. is there a way around them
getting this message?