Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Downloading Data from Website

  Asked By: Kaua    Date: Feb 26    Category: MS Office    Views: 1072
  

This new one is extremely reluctant to return any data using the
QueryTables method; and I have had no success with the SendKeys method
suggested by David G. In the words of another poster on another forum
I read during my seemingly endless Google search: "SendKeys is the
work of the Devil and should be avoided at all costs". I have thrown
time delays and AppActivates into the mix (I use Mozilla Firefox--that
may be a problem with the AppActivate). . .no data ends up on my
worksheet.

Anyway, I surrender--I have been bested by this problem; and now
I am requesting specific code to handle this, if anyone can (and is
willing) to do it--I'm sure it can be done--I just haven't hit the
magic combination. and now I'm reduced to begging, groveling if you
will . . .(no pride at all) . . .:(


Source:
www.donbest.com/.../mlb.shtml?1

Destination:
Application.Workbooks("MLBgeneralpractice.xls") _
.Worksheets("Save1110Lines").Activate
ActiveCell.Select

Goal:
Copy ENTIRE Source page onto Destination sheet OR Copy just the data
onto Destination sheet. Either option is fine.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Charlie Smith     Answered On: Feb 26

Have you tried contacting the site owner to see if there is already
a tool written to do this? The JavaScript for the page  provided seems to
be pulling information off an XML page. With the help of the web master,
you may be able to examine the XML data  directly.

 
Answer #2    Answered By: Daniel Evans     Answered On: Feb 26

If the webmaster is no help though, all the data
is there in these in_line() functions (I opened the page  and clicked View /
Source). So if you do a standard “screen scraping” HttpRequest it would seem
you can still get the data, although I didn’t try…

 
Answer #3    Answered By: Raquel Austin     Answered On: Feb 26

"standard screen scraping" is a little
beyond me at the moment . . .but who knows what the future will bring?

 
Didn't find what you were looking for? Find more on Downloading Data from Website Or get search suggestion and latest updates.




Tagged: