Clearing the office clipboard

[ycim]

I am running a program whereby I do a lot of copy > paste functions from Access. When the office clipboard gets full, the user gets an error.

I saw some discussion on this thread.

http://www.tek-tips.com/viewthread.cfm?qid=1227582

But I am wondering if anyone is able to contribute any solutions or workarounds they may have encountered.

Thanks for your help.

 

[TonyJollans]

I don't know if there's something special in Access but I wouldn't normally expect a full Office clipboard to cause any problem. What error does the user get?


Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[CBasicAsslember]

Use a API call to clear the clipboard.

 

[ycim]

CBasicAsslember...the API call only clears the windows clipboard. It does not clear the office clipboard.

tony...
The error that I am getting is as follows:

Word has insufficient memory. You will not be able to undo this action once it is completed. Do you want to continue?

The problem lies here...I am accessing word through Access to break down some documents. Word is hidden in the background. So, when the error pops up, all the user hears is a "beep" but they cannot see the message. The access application also locks up.



So, I need to find an appropriate workaround. I am just not sure what angle to take for it.

Thanks

 

[TonyJollans]

I have just been reading the other thread so now I understand the background and, if the office clipboard is the problem, you may need an innovative solution.

CBA - What API?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[ycim]

I do agree with the innovative solution part <grin>. I am just not sure what that might be....

I think the API call he is talking about is here

Declare Function CloseClipboard Lib "user32" () As Long
Declare Function EmptyClipboard Lib "user32" () As Long
Declare Function OpenClipboard Lib "user32" (ByVal hWnd As Long) As Long

'this sub empties the API Clipboard
Sub ClearAllClipboard()
    OpenClipboard 0&
    EmptyClipboard
    CloseClipboard
End Sub

 

[TonyJollans]

As you've found out, that API is for the Windows Clipboard.

It seems we have been overlapping in our posts. If memory for Undo is the problem you can clear the Undo buffer - it's certainly worth trying.


Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[ycim]

That is a great suggestion...

Umm...how would one do that?

By the way, I did some searching on the web for any type of solution. It would seem that this frustrates more than just myself. There is an interesting post from someone who obviously has a workaround, but the code is a bit over my head. If anyone wants to "have a go" on how to use it, it may be a worthwhile read.

http://blogs.msdn.com/guowu/archive/2004/12/22/330231.aspx

In the meantime, how does one clear the undo buffer?

Thank you

 

[PHV]

Have you tried to not display the warnings ?
yourWordAppObject.DisplayAlerts = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TonyJollans]

I don't have access to a recent version of Word till tonight but, if I remember, it is (document_ref).UndoClear.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[CBasicAsslember]

CBasicAsslember...the API call only clears the windows clipboard. It does not clear the office clipboard.

My bad, should have looked at it closer.

 

[ycim]

Wonderful suggestions..thanks...I will try them and let you know...stay tuned!