• Hi Guest Just in case you were not aware I wanted to highlight that you can now get a free 7 day trial of Horseracebase here.
    We have a lot of members who are existing users of Horseracebase so help is always available if needed, as well as dedicated section of the fourm here.
    Best Wishes
    AR

Desperate cry for help please

I think your a genius
ArkRoyal said:
If you click on the link you should get 2 choices; one to save the file the other to open it.
I would suggest using the open option.

When the file is open you should see something like this

View attachment 15296

First thing, you need to address the security warning.
Click on Options

View attachment 15297

And Enable the Content and click OK

Then click on Change Folder and select a folder where you want the downloaded data saved.
Then select Get Cards to start the processing of the RP site.
Finally form within Excel save the RPFastCards-3.xlsm to a location on your computer where you can find it again in the future.
Click to expand...
 
I'm not sure whether leftinthestalls leftinthestalls is still around but does anyone know how to make the excellent RPFastCards v1.2.xlsm pick up Newcastle's AW track from the RP?

Otherwise I'm reduced to "cut-paste/fudge about/retype stupid errors" mode :doh:

thanks
ronin
 
TheBluesBrother TheBluesBrother

Sorry I don't have 2016.

Are you running 64bit windows? The code in module4 only relates to selecting the folder to save the file - the main macro should still work.

If not let me know and I'll see what I can do.
 
leftinthestalls said:
TheBluesBrother TheBluesBrother

Sorry I don't have 2016.

Are you running 64bit windows? The code in module4 only relates to selecting the folder to save the file - the main macro should still work.

If not let me know and I'll see what I can do.
Click to expand...

Running Windows 7 Ultimate 64 Bit
Service Pack 1
Microsoft Office Professional Plus 2016

Also received the VB error "module 4".
"Compile error in hidden module: Module4."
 
This suggests issues with the Calendar control.

I have removed it so you need to input the date.
 

Attachments

  • ResultfromSLv1.1.xlsm
    52.5 KB · Views: 28
there are obviously some compatibility issues here.

I have removed everything that I think could cause an issue and redrafted some of the code - unfortunately if this doesn't work there's not a lot more I can do as I only have Excel 2010.

You will have to run the macro from the menu.

Fingers crossed :)
 

Attachments

  • ResultfromSLv1.2.xlsm
    42.4 KB · Views: 57
leftinthestalls said:
there are obviously some compatibility issues here.

I have removed everything that I think could cause an issue and redrafted some of the code - unfortunately if this doesn't work there's not a lot more I can do as I only have Excel 2010.

You will have to run the macro from the menu.

Fingers crossed :)
Click to expand...
Getting error 400, i press OK to close and then the results are showing up, i have tried this on various dates and it will get the results this way. Thank you
 
leftinthestalls said:
there are obviously some compatibility issues here.
I have removed everything that I think could cause an issue and redrafted some of the code - unfortunately if this doesn't work there's not a lot more I can do as I only have Excel 2010.
You will have to run the macro from the menu.
Fingers crossed :)
Click to expand...

I opened up the latest sheet you put up, and there is nothing there, no calendar and no location button.

ResultsSheet.png
 
You must log in or register to reply here.
Back
Top