Sun £9.50 July 2014 Code Words

mrsrabbit_2

izzyroo81 wrote: »

I've got the 'invalid number of tokens passed' error. Do we just wait until the site goes live, or should something happen now when I press on the button 1? It just opens the webpage that says the booking page opens tomorrow.

Yep have to wait till site goes live, but at least it seems to be working as it's linking to the booking page so fingers cossed

Spikeg33

mrsrabbit wrote: »

Dont panic, I'm not an expert, but think it's doing that because site not open yet, it'll only work when the booking page is open:) It's giving you LA02 cause that's the first combo it will check, then it should scroll through the rest of the combos, when the site is live.

Thanks mrsrabbit, that kind of makes sense :embarasse
Will see what happens..............

izzyroo81

mrsrabbit wrote: »

Yep have to wait till site goes live, but at least it seems to be working as it's linking to the booking page so fingers cossed

Thank you - only found this thread last time and you had already cracked it so pleased I can try to help this time.

CherryIceCreamSmile

alexpearce wrote: »

Just adding the lines in won't work as the code isn't in the macro. I 'think' I've altered the macro correctly, but can't test it yet obviously

however, I can't post links, can someone pm me and i'll send it and they can link it

I think Alex is right and you need to edit the macro. I've right clicked on the button box and edited the codey bits (I am evidently NOT an IT person! :rotfl: )

I think just adding extra lines is too simple surely?

:-/

pealy

Has anyone used the cracking spreadsheet recently? I put this together years back to help us get in early but looking at the version I downloaded from this thread I'm not convinced it's up to date enough to work. The first post lists 9 words so we're looking for the tenth right? The spreadsheet works on the basis that we know 7 and are looking for the 8th..

chimpette22

Yes I changed the macro bit too, also not an IT person, but just copy and pasted the lines above and then changed the bits that I knew needed it ie code number... and the box in excel that it is in ie C14, C15

pealy

alexpearce wrote: »

Just adding the lines in won't work as the code isn't in the macro. I 'think' I've altered the macro correctly, but can't test it yet obviously

however, I can't post links, can someone pm me and i'll send it and they can link it

Did you end up with something like this:

.document.forms(0).Item(7).Value = Worksheets("data").Range("C13").Value 'Code 6
.document.forms(0).Item(8).Value = Worksheets("data").Range("C14").Value 'Code 7
.document.forms(0).Item(9).Value = Worksheets("data").Range("C15").Value 'Code 8
.document.forms(0).Item(10).Value = Worksheets("data").Range("C16").Value 'Code 9
.document.forms(0).Item(11).Value = strWord 'Code 10 - the one we are looking for

chimpette22

It was used back in April although didn't work then as the code word was A1A1 (letter, number, letter, number) and these were not included on the sheet.

mrsrabbit_2

My spreadsheet has empty lines under Code 8 line, which is line 15 (left side of page). I just put the word in along side, then in line 16 wrote Code 9 and put the word in that column C and again repeated for Code 10 but left that one blank. I'm not an IT person at all, but it seems to work for me.

pealy

chimpette22 wrote: »

It was used back in April although didn't work then as the code word was A1A1 (letter, number, letter, number) and these were not included on the sheet.

All combinations of LetterLetterNumberNumber have been added to the word list so that should be okay - assuming they haven't created anything more devious.