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.