LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default Google AJAX API from Excel?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AJAX : Dynamlically pushed JavaScript not working after Update Panel is updated Arachnid Excel Programming 0 October 5th 07 10:15 AM
Excel on the web similar to google spreadsheets Alex Excel Discussion (Misc queries) 1 February 24th 07 03:33 PM
Google search box on excel Dileep Chandran Excel Worksheet Functions 7 November 10th 06 04:14 AM
AJAX combo box in excel [email protected] Excel Programming 0 June 20th 06 10:41 AM
Google search from excel Ant[_5_] Excel Programming 1 August 31st 04 08:46 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"