Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ernesta Fernandez   on Feb 04 In MS Office Category.

  
Question Answered By: Nicholas Wells   on Feb 04

I tried inserting the page  you are referring to. Excel would not select  just
the table but I was able to import  the whole page.


I think Excel may rely on the page having named tables and the score table has
no name. (To generate the web  page it does not need one)

The first sub below is the one originally generated.

Then I tried a bit of editing and came up with the amendments (marked with
'*** at the end of the code  line) which actually just call in the data
required (I think).

If all the pages you are calling are in the same format this approach may be
useful to you. If they are all different then it will be a total pain to try
to set them all up.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on "New Web Query" question Or get search suggestion and latest updates.


Tagged: