windows messagebox

[Fred Kruger]

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

 

[Jezebel]

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

 

[Ben M]

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