How can I use VBA to test if the Windows Clipboard is empty? In the past I’ve use the code “Application.CutCopyMode” to test the Excel clipboard status – it returns 1 if the clipboard has contents and it returns 0 if empty. I have a situation that I copy data from Notepad to paste into Excel through an existing VBA application. I’m trying to add an error handling piece should the Windows clipboard it empty what the macro is ran. I discovered that while I can paste from Notebook, “Application.CutCopyMode” still returns a 0. So apparently I need a different way to test the Windows Clipboard than I do the Excel Clipboard. Would appreciate any suggestions. Thanks.
Bookmarks