Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Fingerless Gloves
May 21, 2011

... aaand also go away and don't come back
Just was told I didn't get the job, apparently I did really well but it went to an internal staff instead. So that whole Oh god I'm stuck here feeling is creeping in again, going to apply for a shitload of jobs tonight.

On the other hand, David Cameron hosed a pig head

Adbot
ADBOT LOVES YOU

corn in the fridge
Jan 15, 2012

by Shine
Sorry m8 maybe you shouldve gone in with the goatee after all

Fluo
May 25, 2007

Jose posted:

dr who is poo poo

Fluo
May 25, 2007

free Ratjaculation

feedmegin
Jul 30, 2008

Fluo posted:

free Ratjaculation

Buy one get one free

Bobby Deluxe
May 9, 2004

Fluo posted:

free Ratjaculation
i dont think this is really the best opening offer for a new microbrewery

Fluo
May 25, 2007

Bobby Deluxe posted:

i dont think this is really the best opening offer for a new microbrewery



:getin:

The Big Taff Man
Nov 22, 2005


Official Manchester United Posting Partner 2015/16
Fan of Britches
Ratjac pmd me to ask me to post a pic of Diana as he felt the thread would go to poo poo without one, and hell, it looks like he was right

Aston
Nov 19, 2007

Okay
Okay
Okay
Okay
Okay

I've got you covered, don't worry

oh no computer
May 27, 2003

Fluo
May 25, 2007


illegidly lmao

corn in the fridge
Jan 15, 2012

by Shine
imma have to put a lock on the fridge when jermy corby comes round

Inexplicable Humblebrag
Sep 20, 2003

Jose
Jul 24, 2007

Adrian Chiles is a broadcaster and writer

Ratjaculation posted:

if claudette was in the wire she'd be 'good police'

dutch owns op

Jose
Jul 24, 2007

Adrian Chiles is a broadcaster and writer
the shield loving owns and everyone who hasn't or isn't watching it should

Inexplicable Humblebrag
Sep 20, 2003

Jose posted:

i don't and that would own. i'm currently on open office until we get some copies of office 2016 but since its released tomorrow should be soon

ok so i was going to write something to handle this but actually ended up just finding something instead

it's the final bit of this page with a "save as" bit added: http://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba

http://pastebin.com/QUYUNJLP

i haven't actually tested this in excel i just looked up the properties for the bit i added so if it fails please shout.

it prompts you to pick a folder location then it loops through all files with extensions matching the myExtension variable. it is currently an xls so it will pick up xls's. unfortunately it loops through and actually opens each workbook, which means it might be quite slow if you're doing loads of them.

goatface
Dec 5, 2007

I had a video of that when I was about 6.

I remember it being shit.


Grimey Drawer
Do it in powershell.

I have no idea if you can do it in powershell.

oh no computer
May 27, 2003

Jose posted:

the shield loving owns and everyone who hasn't or isn't watching it should
i watched it years ago and got bored after season 2

Vitamins
May 1, 2012


the best thing excel is for is going to the very last cell on a sheet, putting a dot in it and pressing print

Inexplicable Humblebrag
Sep 20, 2003

goatface posted:

Do it in powershell.

I have no idea if you can do it in powershell.

you can probably do it in powershell, and better

Jose
Jul 24, 2007

Adrian Chiles is a broadcaster and writer

DOWN JACKET FETISH posted:

ok so i was going to write something to handle this but actually ended up just finding something instead

it's the final bit of this page with a "save as" bit added: http://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba

http://pastebin.com/QUYUNJLP

i haven't actually tested this in excel i just looked up the properties for the bit i added so if it fails please shout.

it prompts you to pick a folder location then it loops through all files with extensions matching the myExtension variable. it is currently an xls so it will pick up xls's. unfortunately it loops through and actually opens each workbook, which means it might be quite slow if you're doing loads of them.

cheers. i'm rarely doing more than about 15 but its loving annoying doing that many manually. at least when i'm working with stupidly large spreadsheets they come as csv as standard. turns out no spreadsheet software will handle a 250mb spreadsheet properly which is really annoyng when it has 10 lines of useless poo poo at the start and end

The Big Taff Man
Nov 22, 2005


Official Manchester United Posting Partner 2015/16
Fan of Britches
DOWN JACKET FETISH are you really good with macros

Inexplicable Humblebrag
Sep 20, 2003

no

The Big Taff Man
Nov 22, 2005


Official Manchester United Posting Partner 2015/16
Fan of Britches
drat.

Jose
Jul 24, 2007

Adrian Chiles is a broadcaster and writer
its really annoying that purely to be different open office does all sorts of basic poo poo differently to excel

Inexplicable Humblebrag
Sep 20, 2003

yeah i spent ages dicking around trying to find out how to put a graph in

taff why do you need macros

The Big Taff Man
Nov 22, 2005


Official Manchester United Posting Partner 2015/16
Fan of Britches

DOWN JACKET FETISH posted:

yeah i spent ages dicking around trying to find out how to put a graph in

taff why do you need macros

I thought you might have been able to write a macro that would stop your posts being so bad

Inexplicable Humblebrag
Sep 20, 2003

that's a pretty embarrassing post to make, taff

crispix
Mar 28, 2015

Grand-Maman m'a raconté
(Les éditions des amitiés franco-québécoises)

Hello, dear
i went into a corner shop earlier today and there was a sign above the confectionery stand that said "EATING SWEETS" and it's still bothering me, as far as i could tell there were no sweets about that were for any other purpose :/

goatface
Dec 5, 2007

I had a video of that when I was about 6.

I remember it being shit.


Grimey Drawer
Well duh, you have to ask for it. If you put the nose candy on display you get arrested.

Carpet
Apr 2, 2005

Don't press play
Anyone see 'In Case You Missed It' on BBC2 at 10PM? Should definitely check it out on iPlayer if you didn't.

de la peche posted:

Nice Videogaiden reference there

actually it's more of a rllmuk reference

DrWrestling69
Feb 4, 2008

Tracyanne...

DOWN JACKET FETISH posted:

that's a pretty embarrassing post to make, taff

Taff is a oval office.

Bobby Deluxe
May 9, 2004

Jose posted:

its really annoying that purely to be different open office does all sorts of basic poo poo differently to excel
i dont think they do it to be different i think they do it because it is made by programmers with no pr or marketing or design oversight so they use terms that make sense to them and structure it in a way that makes sense for the code not the user

also use libreoffice

Solefald
Jun 9, 2010

sleepy~capy


DrWrestling69 posted:

Taff is a oval office.

nah

Fluo
May 25, 2007

taff will always be *tibs bedora* to me

corn in the fridge
Jan 15, 2012

by Shine
that joke is so worn out its starting to get embarrassing

Fluo
May 25, 2007

quorn in the freezer

The Big Taff Man
Nov 22, 2005


Official Manchester United Posting Partner 2015/16
Fan of Britches

corn in the fridge posted:

that joke is so worn out its starting to get embarrassing

Its a joke he constantly makes about an avatar he gave me that made no sense and was so stupid that people made fun of the stupidity of it, but he seems to think its a joke about me or offends me.

Fluo
May 25, 2007

calm down taff you're gonna have a stroke

Adbot
ADBOT LOVES YOU

mfcrocker
Jan 31, 2004



Hot Rope Guy
pee-pee
doo-doo
fluo is a bad poster

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply