Forum

Notifications
Clear all

Google Blocked Me

5 Posts
2 Users
0 Reactions
149 Views
(@ehab1511)
Posts: 31
Trusted Member
Topic starter
 

Hi,

Attached macro help me to search about one word in Google and get the result in column B but Google Blocked Me, so can you help me to update the macro to wait between each search for 1 min to avoid the Block.

Thanks;

Ehab

 
Posted : 17/05/2019 6:15 pm
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

Hello,

I do recommend you to check out the blog section, there are great articles to be found there.

https://www.myonlinetraininghub.com/pausing-or-delaying-vba-using-wait-sleep-or-a-loop

 
Posted : 18/05/2019 12:14 am
(@ehab1511)
Posts: 31
Trusted Member
Topic starter
 

Hi Anders,

Grateful for your support. I tried to use below in macro but I got issue to run it, so could you please help me to update the code in attached macro.

Application.Wait (Now + TimeValue("0:00:50")) 'Wait for 50 seconds

Thanks;

Ehab

 
Posted : 18/05/2019 5:28 pm
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

Hello,

What kind of issue do you have when running the code? Is it what Philip writes in his article?

"The big drawback of using Wait or Sleep, is that Excel locks you out until the wait/sleep period has finished. You can use CTRL+BREAK to interrupt the macro, but Excel won’t accept input from the keyboard or mouse whilst paused using Wait or Sleep."

 
Posted : 19/05/2019 10:42 am
(@ehab1511)
Posts: 31
Trusted Member
Topic starter
 

Now.  It works perfectly. Thank you so much! 

Thanks;

Ehab

 
Posted : 22/05/2019 8:01 am
Share: