Display Alerts

[ColinKJ]

Hi All,

Sorry, this may be a bit naughty, it's a Word VBA throwing up display alert for <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
"There's a large amount of data on the paste board, do you want to keep it"<o></o>
<o></o>
Or something to that effect. <o></o>
<o></o>
I have included the Application.DisplayAlerts=False<o></o>
<o></o>
but it still comes up every time.<o></o>
<o></o>
As I'm attempting to copy data (TextBox's) from the Word Document and then Paste them into XL form a large number of document, I need to suppress the Alert.<o></o>
<o></o>
Any suggestions please.
<o></o>
Regards

ColinKJ

 

[GTO]

Greetings,

If you are closing the App (Word), leastwise before pasting, I don't think you'll get around the warning. You may wish to post your code as is, so we can see what's happening?

Mark

 

[Colin Legg]

Hi Colin,

You can try clearing the clipboard before closing the doc:

Dim MyData As DataObject

Set MyData = New DataObject
MyData.SetText ""
MyData.PutInClipboard

This code is taken from this site:
http://www.word.mvps.org/FAQs/MacrosVBA/ManipulateClipboard.htm

A note: a reference to the Microsoft Forms 2.0 Object library is required.

Does that fix it for you?

 

[ColinKJ]

Thanks everyone for all the ideas, but I found out why I was creating so much on the clipboard, which wasn't necessary.

Now I've revised the code all ok.

Thanks again for all your help

ColinKJ