Thanks for the replies. I am as sure as I can be that the problem is that the Copy to the clipboard is the bit that doesn't work. The web application I am screen-scraping from doesn't have any page structure so I have to look for particular items on the screen by matching them to a bitmap image and ...

Have tried putting the Wait> statements in as suggested but this doesn't solve the problem. I have tried this code on a variety of different PCs. On some the clipboard contains the correct data 75% of the time but is empty 25% of the time. On others it is empty 100% of the time. I have tried setting...

Hi Gale Thanks for the thoughts. The PosX, PosY co-ordinates are set earlier in the code, based on searching for an image and then offsetting by a set number of columns/rows from where the image is found. Also the window is maximised earlier on in the code too - the code works fine up to the Ctrl A ...

I realise that I haven't replied for a long time on this one but I have never managed to find an answer. I tried adding Waits at lots of different places in the code; in between each of the "Press Ctrl" lines etc, wrote the clipboard data to a variable and found that the clipboard was empty each tim...

Bob Thanks for the thoughts. Once I have done the "Copy" I set Focus back to Excel, use a shortkey to kick off an Excel macro and attempt to Paste the data into the right place on the spreadsheet. I have an error-trap at this point which picks up if the clipboard is empty and lets me manually copy i...

Hi I am having trouble with a bit of code I'm using to capture data from a webpage and paste it to Excel. All I am doing is looping through a series of webpages, all of which have the same layout. Selecting the page, copying (using Control A, then Control C) and passing it to the clipboard. The code...