Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Harry Hunter   on Jan 31 In MS Office Category.

  
Question Answered By: Volker Fischer   on Jan 31

However your WebQuery answer, while entirely accurate, does not
address the specific situation that I have (mainly because I didn't
explain it in detail). I just download the whole page, with no table
selection necessary, since WebQuery has the problems you described.

So here it is--a very simple situation: These are the steps that I do
physically and that I would like to accomplish with a macro:

1. Go to
www.donbest.com/.../all-games.shtml?20070408
(note that this page can be easily activated by hyperlink)
(note that the last 8 digits are the date, which can be easily
incremented by macro)

2. Click Edit
3. Click Select All
4. Click Copy

5. Key Control z on the keyboard. This activates a macro that I have
already created. This macro simply goes to the active cell on my
excel sheet, does a "paste special" with the HTML selection  (default),
then selects "match destination formatting", then chops off all the
extra garbage that I don't want, leaving only the table of data  that I
do want in the proper place on the worksheet.

So all I'm asking a new macro to do is steps 2,3, and 4. It blows my
mind that people are telling me it can't be done.

Share: 

 

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

 
Didn't find what you were looking for? Find more on Database Overview Question Or get search suggestion and latest updates.


Tagged: