6th February 2012, 08:09 PM
|
|
Member
|
|
Join Date: Jan 2012
Posts: 282
|
|
Ok, I did not include the entire macro, only the section.
-----------------------------
Quote:
|
What do you use to get the race times in order and where do you get them?
|
It's in another workbook
using the old html code
Quote:
With Selection.QueryTable
.Connection = "URL;http://tatts.com/racing/" & Range("A1") & ".html"
|
Cell A1 is: 2012/02/06/raceday
This brings up the entire race card
----------------------------------
Quote:
I was having a look at your last sheet the screen updating is doing twice the work, have it set like this
Application.ScreenUpdating = False
Rest of macro here
Application.ScreenUpdating = True
What that does is stops the screen updating so it just looks like the info appears and you don't see the macro working, if you do the same for the clean up macro will look smother.all the
|
Yes, I am still tweaking as I go along.
I'll post the new day's race list tomorrow at around just past 9.AM.
I need the RESULTS though or the project/workbook cannot be completed, and won't be able to get past BASIC 3.
Thanks
Puntz
|