Here is the URL he is trying to copy/query:
http://www.racingpost.com/greyhounds/card.sd

See this thread for more information (note that the linked thread was originally about cleaning up an existing macro, whereas the OP is now requesting, if possible, to replace the current method of manually copying the tables and the running a cleanup macro with a macro that draws the data directly from the webpage to eliminate the need for a cleanup macro):
http://www.excelforum.com/excel-prog...-outputes.html

I really don't know anything about Data.Object in MS Forms 2.0 library and so recommended he start a new thread in the hopes of attracting a more knowledgable forum member.