How to avoid the "There is a large amount of data in the clipboard... " dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith B - 20 Feb 2005 00:02 GMT

I have a Word VBA Subroutine the opens an excel spreadsheet, copies a range
into the clipboard, closes the excel application, and then pastes the
information from the clipboard into the word document. I am getting the
"There is a large amount of data in the clipboard... " dialog box. How can I
disable this feature from within my Word VBA subroutine?

Thanks,

Keith

Reply to this Message

Jezebel - 20 Feb 2005 00:12 GMT

Copy something small to the clipboard before exiting. (eg, select the first
character of your document and copy that).

Better is not to use the clipboard at all. There are easier ways to transfer
data from Excel to Word (eg, read the Excel Range into a variable).

>I have a Word VBA Subroutine the opens an excel spreadsheet, copies a range
>into the clipboard, closes the excel application, and then pastes the
[quoted text clipped - 5 lines]
>
> Keith

Reply to this Message

Peter_A_M (NL) - 22 Feb 2005 12:45 GMT

... but if you do want to use this method:
With Application.DisplayAlerts = wdAlertsNone at least you suppress the
message.
(In that case the default option is chosen.)
Don't forget to restore to Application.DisplayAlerts = wdAlertsAll within
your code!

Peter

> Copy something small to the clipboard before exiting. (eg, select the first
> character of your document and copy that).
[quoted text clipped - 11 lines]
> >
> > Keith

Reply to this Message