Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Jul 17, 12:22*am, Martin Schneider <martin.schnei...@illusion-
factory.de wrote: Matthew Herbert schrieb: On Jul 16, 8:43 am, Martin Schneider <martin.schnei...@illusion- factory.de wrote: Joel schrieb: I don't know. *I will search around the web later but not sure if I will find anything. Thanks for your efforts. In the meantime I learned that this feature is in the pipeline... :-) Best regards Martin As an aside, I scripted a Google search the other day and would get automatically booted off after about 200 consecutive searches (in a loop of 1,300). *(I got that page stating that I looked like a virus and I needed to insert the text from the picture in order to continue searching). *I resolved the issue by deleting the google related search cookies in the Temporary Internet Files folder after each 200th time through the loop. Hi, thanks! That sounds interesting! Do you script the Internet Explorer or use the Microsoft.XMLHTTP object? * (Or maybe this doesn't matter as the IE does this, too :-)) Thanks and best regards, Martin- Hide quoted text - - Show quoted text - Martin, I scripted IE (much like the code Joel provided in the thread) and then used the FileSystemObject to delete the Google search cookies in order to prevent the Google "error" page from appearing. (In order to get a sense of timing, it would take about 8 minutes to loop through the ~1,300 searches, but this time includes the time it took to delete the cookies every 200th time and the time to "get" the data off the search page). If I'm getting stock price information off of say Yahoo!, then I use XMLHTTP because it is much faster than scripting IE. (But then again, I don't find myself automating the Internet that often either). Best, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AJAX : Dynamlically pushed JavaScript not working after Update Panel is updated | Excel Programming | |||
Excel on the web similar to google spreadsheets | Excel Discussion (Misc queries) | |||
Google search box on excel | Excel Worksheet Functions | |||
AJAX combo box in excel | Excel Programming | |||
Google search from excel | Excel Programming |