windows messagebox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred Kruger - 29 Jun 2005 16:18 GMT

i have created a subprocedure that opens docum,ents and copies details from
the to be added to a document it then closes the document but i get the
message "you have copied a large ammount of data to the clipbourd do you wish
to make it available to others or words to that effect.

i dont wish to save it and want for this message not to show eachtime is
there anyway i can switch this off whilst running the subroutine?

Fred

Reply to this Message

Jezebel - 29 Jun 2005 17:20 GMT

Simplest is just to copy something else (ie something small) to the
clipboard before closing the document.

>i have created a subprocedure that opens docum,ents and copies details from
> the to be added to a document it then closes the document but i get the
[quoted text clipped - 6 lines]
>
> Fred

Reply to this Message

Ben M - 30 Jun 2005 12:14 GMT

You need to clear the clipboard before closing.

This way works fine, as long as you reference the Microsoft Forms 2.0 Object
Library (or just add a blank form to your project and remove it).

Sub ClearClipboard()
Dim oDataObject As DataObject
Set oDataObject = New DataObject
oDataObject.SetText ""
oDataObject.PutInClipboard
Set oDataObject = Nothing
End Sub

Cheers! Ben

> Simplest is just to copy something else (ie something small) to the
> clipboard before closing the document.
[quoted text clipped - 9 lines]
> >
> > Fred

Reply to this Message