Bits and Bobs 35

Zardoz · **Posted:** Thu Jul 19, 2012 16:38

Distinctly average.

Grim... · **Posted:** Thu Jul 19, 2012 16:38

WTB wrote:

Distinction: Confirmed! Woo!

Okay, so what does this mean? What next?

Bamba · **Joined:** 25th Jul, 2010 **Posts:** 11128

Grim... wrote:

Okay, so what does this mean? What next?

WTB gets really drunk.

WTB · **Joined:** 27th Mar, 2008 **Posts:** 14497

I got my grades earlier and had to work out the average myself, but I just got an email that specifically says "distinction".

Now I need to get myself a training contract and properly start my life. Finally!

(A distinction is the equivalent to a First in degree speak, or an "A" I guess.)

Grim... · **Posted:** Thu Jul 19, 2012 16:42

WTB wrote:

Now I need to get myself a training contract and properly start my life. Finally!

Yeah, but - doing what?

WTB · **Joined:** 27th Mar, 2008 **Posts:** 14497

TheVision · **Posted:** Thu Jul 19, 2012 16:45

Robocop then.

Excellent news!

MaliA · **Posted:** Thu Jul 19, 2012 18:30

Bunch of teenage kids laughed at me on my way to (The Co-Op - Ed) as I was wearing a cardigan. I then realized that I own 4 cardigans and they are my "not at work" clobber. I'm turning into the sartorial equivalent of Kissyfur.

Mr Dave · **Posted:** Thu Jul 19, 2012 18:34

WTB wrote:

Law!

Did you do this just so that you could argue with Myp The Last Salmon Berk more accurately?

WTB · **Joined:** 27th Mar, 2008 **Posts:** 14497

Well there's no point doing things by halves.

MaliA · **Posted:** Thu Jul 19, 2012 19:41

WTB wrote:

I got my grades earlier and had to work out the average myself, but I just got an email that specifically says "distinction".

Now I need to get myself a training contract and properly start my life. Finally!

(A distinction is the equivalent to a First in degree speak, or an "A" I guess.)

First up, as your lass is away, you should go to a lap dancing club and tell the girl "I just passed my law exams". This is an A1 idea.

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 26103

WTB wrote:

Law!

huh!

What is it good for?

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

I agree with Mali.

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 26103

Say it again now!

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

I agree with Mali.

Goddess Jasmine · **Posted:** Thu Jul 19, 2012 20:51

Well done WTB!

ApplePieOfDestiny · **Joined:** 17th Dec, 2008 **Posts:** 8293

I'd like to think that if John Grisham chose to vary the formulaic nature of his books, which focus on a law student who had problems which delayed his studies, but against the odds passed with flying colours, and was immediately thrown into a massive high profile case against EvilMegaCorp and won against the odds - by making the lead character english, he'd call him Wogans Trouser Bulge.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11898

okay, here is a link to today's episode of Pointless on BBC one:
http://www.bbc.co.uk/iplayer/episode/b0 ... Episode_8/
Skip to 34:00 and listen to the question, then listen to the woman's answer and put your thoughts here.

Dimrill · **Posted:** Thu Jul 19, 2012 21:08

She got the question wrong.

Malc · **Posted:** Thu Jul 19, 2012 21:08

I went for Lamont, and got 10, I was surprised, I thought it would be higher!

As for the woman, she said she wasn't sure if he was conservative, I suspect she couldn't think of anyone else, and remembered that he had been chancellor, so was worth a punt.

Malc

ApplePieOfDestiny · **Joined:** 17th Dec, 2008 **Posts:** 8293

She needs to got to a retraining camp.

Goddess Jasmine · **Posted:** Thu Jul 19, 2012 22:05

Some of you might appreciate this. Love and Minecraft: A Very Nerdy Wedding.

Dimrill · **Posted:** Fri Jul 20, 2012 1:30

When Meats and Petes visited me last month we had a good chuckle about He-Man as good people are wont to do. During which I mentioned X-Entertainment's Modulok review having me in stitches some 12 years ago on his blog, and I just done founded it! http://www.x-entertainment.com/articles/0885/ S'not porn, promise. And as a bonus I found he'd launched a new site Dinosaur Dracula. Fresh.

TheVision · **Posted:** Fri Jul 20, 2012 9:20

Excellent find Dimrill! I loved X-entertainment but stopped reading it a while ago as it wasn't updated as often as I'd have liked.

Looks like I've got a new site to spend today reading then.

metalangel · **Posted:** Fri Jul 20, 2012 9:24

The video I mentioned during said conversation was this one (SFW)

ZOMG Spoiler! Click here to view!

"I've decided to kill myself, falling backwards onto an axe the way I always talked about." :DD

nickachu · **Posted:** Fri Jul 20, 2012 9:25

WTB wrote:

Now I need to get myself a training contract and properly start my life. Finally!

I was supposed to do that 3 years ago. Now I'm an overqualified chef in Sweden. Let's see where you end up!

Zardoz · **Posted:** Fri Jul 20, 2012 9:25

Craster wrote:

I agree with Mali.

nickachu · **Posted:** Fri Jul 20, 2012 9:27

Bobbyaro wrote:

okay, here is a link to today's episode of Pointless on BBC one:
http://www.bbc.co.uk/iplayer/episode/b0 ... Episode_8/
Skip to 34:00 and listen to the question, then listen to the woman's answer and put your thoughts here.

Not available in my region

Grim... · **Posted:** Fri Jul 20, 2012 9:29

http://www.watchuktv.co.uk/

MaliA · **Posted:** Fri Jul 20, 2012 9:56

10 dead at Batman premier in Denver, Colorado.

EDIT:" masked gunman has shot dead 10 people and wounded 30 to 40 others at a showing of new Batman movie The Dark Knight Rises at a cinema in the US city of Denver, local radio station KOA reports. More details soon " says the newswires.

Trooper · **Joined:** 4th Mar, 2010 **Posts:** 22396

MaliA wrote:

10 dead at Batman premier in Denver, Colorado.

EDIT:" masked gunman has shot dead 10 people and wounded 30 to 40 others at a showing of new Batman movie The Dark Knight Rises at a cinema in the US city of Denver, local radio station KOA reports. More details soon " says the newswires.

Blimey!

KovacsC · **Posted:** Fri Jul 20, 2012 10:07

nickachu wrote:

WTB wrote:

Now I need to get myself a training contract and properly start my life. Finally!

I was supposed to do that 3 years ago. Now I'm an overqualified chef in Sweden. Let's see where you end up!

Who got 8:30 on Friday for Sweden to be mentioned

nickachu · **Posted:** Fri Jul 20, 2012 10:12

KovacsC wrote:

nickachu wrote:

WTB wrote:

Now I need to get myself a training contract and properly start my life. Finally!

I was supposed to do that 3 years ago. Now I'm an overqualified chef in Sweden. Let's see where you end up!

Who got 8:30 on Friday for Sweden to be mentioned

*cough* hour ahead *cough*

zaphod79 · **Joined:** 16th Apr, 2008 **Posts:** 14518

KovacsC wrote:

nickachu wrote:

Who got 8:30 on Friday for Sweden to be mentioned

*cough* hour ahead *cough*

Why would there be an hours difference , all of the UK is in the same timezone ?

nickachu · **Posted:** Fri Jul 20, 2012 10:18

Because it was a later time here.... erm...

KovacsC · **Posted:** Fri Jul 20, 2012 10:26

here....

go on you had to stop yourself saying Sweden... :DD

YOG · **Posted:** Fri Jul 20, 2012 12:00

MaliA wrote:

10 dead at Batman premier in Denver, Colorado.

EDIT:" masked gunman has shot dead 10 people and wounded 30 to 40 others at a showing of new Batman movie The Dark Knight Rises at a cinema in the US city of Denver, local radio station KOA reports. More details soon " says the newswires.

I notice a lot of the news sites keep mentioning the killer's attire, which reminds me of this rather important point.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11898

Why am I getting a syntax error on the line "wbk.Close(SaveChanges:=False)"

Edit, It is saying "expected ="

Code:

Sub plotAll()


Dim fs As FileSearch
Dim i As Integer
Dim wbk As Workbooks

Set fs = Application.FileSearch

With fs
    .LookIn = ThisWorkbook.Path
    .fileName = "*.xls"
    For i = 1 To .Execute()
        Set wbk = Workbooks.Open(.FoundFiles(i))
        Call TimePlotter
        wbk.Close(SaveChanges:=False)
    Next i
End With
End Sub

Trooper · **Joined:** 4th Mar, 2010 **Posts:** 22396

Remove the brackets.

wbk.Close SaveChanges:=false

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11898

Then I get a "Wrong number of arguments or invalid property assignment" message highlighting the ".Close"

Trooper · **Joined:** 4th Mar, 2010 **Posts:** 22396

Hmm....

Dunno then! Some sort of oddity around nesting the close in a loop I guess.

Ask MaliA.

Mr Russell · **Joined:** 6th Apr, 2008 **Posts:** 12337

wbk.close.savechanges:=false ??

That's a guess. I'm learning.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11898

Nope, I have tried a number of things, I am using Excel 2003 so its possible the function doesn't exist, but I can't even say wbk.Close().

Grim... · **Posted:** Fri Jul 20, 2012 12:40

The search function is free to use, everyone! And it searches topic titles, too!

Grim... · **Posted:** Fri Jul 20, 2012 12:42

Bobbyaro wrote:

Nope, I have tried a number of things, I am using Excel 2003 so its possible the function doesn't exist, but I can't even say wbk.Close().

Try taking the brackets off that?

Aren't you meant to put the file name into the workbooks object, though?

Code:

wbk = workbooks("lalala.xls")

MaliA · **Posted:** Fri Jul 20, 2012 12:42

wbk.Close savechanges:=False

might work.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11898

Solved it - in my messing around I changed
Dim wbk As Workbook to Dim wbk As Workbooks
It works without the brackets. Thanks all.

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

What's with the use of parameter names in functions? Everyone seems to be doing it, and I've never seen it before people on this forum.

Grim... · **Posted:** Fri Jul 20, 2012 12:46

Craster wrote:

What's with the use of parameter names in functions? Everyone seems to be doing it, and I've never seen it before people on this forum.

EXAMPLIZE!

Because all I'm getting from that is that you've never seen

Code:

function someFunction (someVariable) {...

before...

MaliA · **Posted:** Fri Jul 20, 2012 12:46

Craster wrote:

What's with the use of parameter names in functions? Everyone seems to be doing it, and I've never seen it before people on this forum.

The book I have encourages it.

Be Excellent To Each Other

Bits and Bobs 35
The thread for *

Who is online

Be Excellent To Each Other

Bits and Bobs 35 The ****** thread for *******

Who is online

Bits and Bobs 35
The thread for *