Sun Holidays 2011 code words thread

milky1965

pealy wrote: »

My arm started to ache so I've knocked up a (very rough & ready - no abuse please) spreadsheet to check instead. If anyone wants to give it a try its at http://pealy.co.uk/Documents/SunWebChecker.xlsm.

Basically you put your registration details etc in the Data tab, the list of words in column A of the Words tab, enter a number for the line you want it to start at (in the data tab) and click the button.

It opens an explorer window and puts the resulting message in column B of the words tab. If it gets anything other than "Please enter 8 valid and unique token codes" it pops up a message box.

To stop it, just close the explorer window and it will error and stop.

thanks, trying this now (once I finally figured out how to do it):o

devlin

lindaflood wrote: »

Think we might have more luck trying to get a nice lorry driver, who delivers the morning papers to text us the word, in the middle of the night!!! anyone know anyone like that????
Or from a 24 hr supermarket?

My Hubby's a lorry driver and working tomorrow morning! He could probably let me know by 5ish. I am sure it will be live tonight though. Will check on here when I finish work tonight and if the word hasn't been guessed I will get him to text me as soon as and post on here.

KatCJ

pealy wrote: »

Nope! But I did test that it popped up a message if it gets back anything other than "Please enter 8 valid and unique token codes".

Cool, hehe, not that I'm desperate to get this holiday booked or anything! Just one more question.... do you know if it works with Open Office cos that's what I have on my laptop and currently I'm having problems getting it to open up in anything other than read only. Thanks again for taking the trouble to do it!

Mr_Doovde

pealy wrote: »

My arm started to ache so I've knocked up a (very rough & ready - no abuse please) spreadsheet to check instead. If anyone wants to give it a try its at http://pealy.co.uk/Documents/SunWebChecker.xlsm.

Basically you put your registration details etc in the Data tab, the list of words in column A of the Words tab, enter a number for the line you want it to start at (in the data tab) and click the button.

It opens an explorer window and puts the resulting message in column B of the words tab. If it gets anything other than "Please enter 8 valid and unique token codes" it pops up a message box.

To stop it, just close the explorer window and it will error and stop.

You are a f*'#ing genius

pealy

KatCJ wrote: »

Cool, hehe, not that I'm desperate to get this holiday booked or anything! Just one more question.... do you know if it works with Open Office cos that's what I have on my laptop and currently I'm having problems getting it to open up in anything other than read only. Thanks again for taking the trouble to do it!

Hi - I don't know sorry, it's actually a macro within the spreadsheet that does all the work and I have no idea whether they're supported by Open office.

melvis

KatCJ wrote: »

Cool, hehe, not that I'm desperate to get this holiday booked or anything! Just one more question.... do you know if it works with Open Office cos that's what I have on my laptop and currently I'm having problems getting it to open up in anything other than read only. Thanks again for taking the trouble to do it!

It shows read only when I open it in word too xx

pealy

Mr_Doovde wrote: »

You are a f*'#ing genius

Thank you kindly, if only I could find a way to turn Excel Macro's into hard cash I'd be rich too!

lindaflood

devlin wrote: »

My Hubby's a lorry driver and working tomorrow morning! He could probably let me know by 5ish. I am sure it will be live tonight though. Will check on here when I finish work tonight and if the word hasn't been guessed I will get him to text me as soon as and post on here.

That would be great, if we havent cracked it by then !!!:T Thanks

pealy

melvis wrote: »

It shows read only when I open it in word too xx

Try Excel..!

It probably requires your PC to have a slightly relaxed attitude to security.. Sorry if it doesn't work for you but it was only a quick job.

melvis

pealy wrote: »

Try Excel..!

It probably requires your PC to have a slightly relaxed attitude to security.. Sorry if it doesn't work for you but it was only a quick job.

Oops I meant Excel! xx