Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 2nd February 2012, 05:34 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

If you look under tools then macro you will find the recorder there for 2003.

One thing i forgot to mention with excel 2007 onward is when you go to save the file the first time you need to change the file type to "Excel Macro Enabled Workbook"

Once that is done you can save it each time you close it.
Reply With Quote
  #12  
Old 3rd February 2012, 12:06 AM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 291
Default

Done BASIC 1

Did not do THE BASICS PART 2 cos I already do that with cell refs.

good show,

Thanks
Reply With Quote
  #13  
Old 4th February 2012, 09:55 AM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 291
Default race lists 20120204

The tatts url to get a racelist is
in cell A1
2012/02/04/raceday

With Selection.QueryTable
.Connection = "URL;http://tatts.com/racing/" & Range("A1") & ".html"

Then there is a series of macro to get it to go to columns

For some reason it won't work when I try . & Range("A1") & ".xml"
Attached Files
File Type: zip DAILY RACE LIST-20120204.zip (28.4 KB, 790 views)
Reply With Quote
  #14  
Old 4th February 2012, 10:54 AM
Robot Robot is offline
Member
 
Join Date: Jan 2011
Posts: 27
Default ROBOT

Shaun.Thanks for your basics training.Can manage all up to modules Where do I find them.If double click modules in the drop down it goes to module 2.What am I doing wrong.Have got the page for MR1 up but all I get is sheet1(code) Would like to continue to learn more as discussed before Maybe a slow learner.

Tom the ROBOT
Reply With Quote
  #15  
Old 4th February 2012, 11:03 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

No macros on that sheet, also you don't need it in a zip file you can just upload the file, but i am sure the Zip file reduces the size if you are using an older excel.

For those that wish to use a new version of excel you can get a trial copy for free that will last you 6 months, at the end of 6 months you have 3 choices.

1) Continue to use the program and get a popup when opening saying it is unregistered and not be able to update but all functionality is the same.
2) Format your hard drive and re install the program and have it again for 6 months.
3) Purchase the program.

I use option 2 but if i am lazy option 1 is sometimes in effect, has been for the last 2 years.
Reply With Quote
  #16  
Old 4th February 2012, 11:14 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

This is what you should see when you open the VBA editor, you may have 2 or more modules depending on how many macros you created.
Attached Thumbnails
Click image for larger version

Name:  VBA.gif
Views: 832
Size:  6.8 KB  

Last edited by Shaun : 4th February 2012 at 11:17 AM.
Reply With Quote
  #17  
Old 4th February 2012, 11:19 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Someone needs to teach me how to post images that you can see but are not to large to upload.
Reply With Quote
  #18  
Old 4th February 2012, 11:35 AM
Neurokahuna Neurokahuna is offline
Member
 
Join Date: Sep 2006
Posts: 18
Default

HI Puntz,

I've been caught out in this same issue before and the Unitab XML feeds can be a little misleading in this respect.

It may relate to the format of the date you are using in cell A1. I notice you have it in YYYY/MM/DD format, but I've found that when it is a single digit day and single digit month (i.e. 2012/01/04), Unitab's xml feed can't interpret it. It needs to be changed to 2012/1/4

To reformat cell A1, right-click on it, select Format Cells, then Numbers tab, then Custom from the Formattingh Options.

In the 'Type:' field, enter 'YYYY/M/D' and it should now display the date as 2012/1/4, instead of 2012/01/04.

Don't worry, it will still interpret 2012/10/10 correctly.

Hope this helps.

Neurokahuna
Reply With Quote
  #19  
Old 4th February 2012, 12:59 PM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 291
Default

Thanks Neurokahuna

I'll work on your suggestions later and do some tests.

Have uploaded the current date method.
The point is eliminating as much typing as possible so no typo errors happen.
I hope the right format will happen on this same worksheet.

By all means correct it if so to make it work like it ought to,
show and tell is appreciated.

Puntz
Attached Files
File Type: xlsm TATTS RACELIST-2.xlsm (35.5 KB, 815 views)
Reply With Quote
  #20  
Old 4th February 2012, 01:03 PM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 291
Default

Quote:
Shaun Someone needs to teach me how to post images that you can see but are not to large to upload.


Open MS Paint
Print Screen and Paste to Paint
Save
Close

Then upload here, usually works.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:26 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655