Desperate cry for help please
- Thread starter pinemarten
- Start date
leftinthestalls
Yearling
It compiles ok for me - perhaps it's the MSForm controls reference. (fm20.dll) that's causing the issue.
I've changed the buttons to activeX controls - is this any better?
I've changed the buttons to activeX controls - is this any better?
leftinthestalls
Yearling
top man! Glad you got it sorted.
pinemarten
Sire
Ark / everybody,
Still struggling big time.
Your #22 is exactly what I am after but.....
The copy / paste special (or paste) gets the text into excel but like I explained earlier it is all over the place.
I have tried to format the cells like rpjd suggested but the text is as above.
Regards,
Still struggling big time.
Your #22 is exactly what I am after but.....
The copy / paste special (or paste) gets the text into excel but like I explained earlier it is all over the place.
I have tried to format the cells like rpjd suggested but the text is as above.
Regards,
ArkRoyal
Administrator
Have you downloaded the sheet kindly put up by
leftinthestalls
If not do so and try it out.
leftinthestalls If not do so and try it out.
pinemarten
Sire
Ark,
I assume when you say down load you me "save as" ( told you I was computer dinosaur).
If so before I save as I notice there are several options within excel as to where to save it, ie - excel workbook, excel open document spreadsheet, etc.
Where do I save it too?
TY
I assume when you say down load you me "save as" ( told you I was computer dinosaur).
If so before I save as I notice there are several options within excel as to where to save it, ie - excel workbook, excel open document spreadsheet, etc.
Where do I save it too?
TY
ArkRoyal
Administrator
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
First thing, you need to address the security warning.
Click on Options
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.
I would suggest using the open option.
When the file is open you should see something like this
First thing, you need to address the security warning.
Click on Options
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.
Pitmatic
Colt
leftinthestalls and
ArkRoyal - just downloaded the file and had a little play around with it, works like a dream - thanks very much for this, I'm sure I'll find a use for it!!
pinemarten
Sire
Ark,
Bingo / hooray/ hallelujah / ....................
You beauty
Thanks everybody. You are a great bunch.
Kind regards,
Bingo / hooray/ hallelujah / ....................
You beauty
Thanks everybody. You are a great bunch.
Kind regards,
rpjd99
Colt
pinemarten
Sire
leftinthestalls / rpjd,
True gents.
TY kindly,
True gents.
TY kindly,
TheBluesBrother
Dam
Somethingtohide
Yearling
I am using Windows 7 X64 and Excel 2013
but I am getting the following error...
Subscript out of range (Error 9)
How can I fix this please
but I am getting the following error...
Subscript out of range (Error 9)
How can I fix this please
leftinthestalls
Yearling
Somethingtohide
Yearling
leftinthestalls Thank you, working perfect now
leftinthestalls
Yearling
updated version to show the Draw separately
Brigadier1
Yearling
Graeme
Sire
Nice bit of kit - thanks for sharing
mickfbrown
Yearling
excellent, thank you!