Clipboard Oddities

Maslan · Apr 3rd, 2002, 06:15 PM

Hi guys,
I used Excel vba to control a 'VBA-enabled' software... basically what I am doing is a fast copy-paste operation...
My problem is:
- Sometimes I get a message - something like, "Excel cannot perform the requested operation because the clipboard is empty" - even though the method copy is called before the paste code..

Question:
- Is there a way using vba to check the contents of the clipboard, wether empty or full... and is there a way to programatically empty the clipboard.
- If there isn't, is there a Win32 API call I can explore??

Thanks guys..

Juan Pablo González · Apr 3rd, 2002, 06:22 PM

To delete:

Application.CutCopyMode = False

or

Private Declare Function EmptyClipboard Lib "user32" () As Long

Maslan · Apr 3rd, 2002, 06:38 PM

Cheers...

Apr 3rd, 2002, 06:22 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	To delete: Application.CutCopyMode = False or Private Declare Function EmptyClipboard Lib "user32" () As Long __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 06:15 PM	#1
Maslan New Member Join Date: Mar 2002 Posts: 11	Hi guys, I used Excel vba to control a 'VBA-enabled' software... basically what I am doing is a fast copy-paste operation... My problem is: - Sometimes I get a message - something like, "Excel cannot perform the requested operation because the clipboard is empty" - even though the method copy is called before the paste code.. Question: - Is there a way using vba to check the contents of the clipboard, wether empty or full... and is there a way to programatically empty the clipboard. - If there isn't, is there a Win32 API call I can explore?? Thanks guys..

Apr 3rd, 2002, 06:38 PM	#3
Maslan New Member Join Date: Mar 2002 Posts: 11	Cheers...