Attached is the code I am using for accessing the clipboard. When I try to get the data from the clipboard to check to see if it is blank, Access locks up. I have APIs to get data from the clipboard, send data to the clipboard, and clear the clipboard. So, rather than trap for the error when I try to paste, I want to check to see if the clipboard has anything on it. One problem is that Access moves to fast after the page is loaded and the select all does not happen all the time and when it does the copy does not finish before it needs to be pasted into excel. From there I pull it into access and use the results. I am able to select all and copy the entire page so it can be pasted into MS excel.
I am using InternetExplorer application object to access a specific page, paste in certain data, then wait for the results. I am trying to find a way to check if the clipboard has anything on it, without crashing Access in the process.
0 kommentar(er)
