Hello everybody. I'm struggling with scraping data from the web with sendkeys method. I'm now in a situation where, apparently SendKeys "^c" works but SendKeys "^v" has not effect. I mean: at the end of the failing macro, if I manually do ctrl+v, in sheet 3 cell A1 appears what I've copied with SendKeys "^c". Any ideas? SendKeys "^a" Application.Wait (Now + TimeValue("0:00:03")) SendKeys "^c" Application.Wait (Now + TimeValue("0:00:03")) AppActivate ("Microsoft excel") Sheets(3).Select Range("A1").Select Application.Wait (Now + TimeValue("0:00:10")) SendKeys "^v" Application.Wait (Now + TimeValue("0:00:10"))

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Vba and Excel: scraping data from the web, SendKeys "^c" doesn't work

Thread starter Nelson78
Start date Jan 22, 2019
Tags

application.wait sendkeys timevalue00003 timevalue00010 web

Nelson78

Well-known Member

Jan 22, 2019

Hello everybody.

I'm struggling with scraping data from the web with sendkeys method.

I'm now in a situation where, apparently SendKeys "^c" works but SendKeys "^v" has not effect.
I mean: at the end of the failing macro, if I manually do ctrl+v, in sheet 3 cell A1 appears what I've copied with SendKeys "^c".

Any ideas?

Code:

SendKeys "^a"
Application.Wait (Now + TimeValue("0:00:03"))

SendKeys "^c"
Application.Wait (Now + TimeValue("0:00:03"))

AppActivate ("Microsoft excel")

Sheets(3).Select
Range("A1").Select

Application.Wait (Now + TimeValue("0:00:10"))

SendKeys "^v"

Application.Wait (Now + TimeValue("0:00:10"))

Last edited: Jan 22, 2019