I'm installing M$ office 2007
The installation is officially wank.

I checked out the "custom" installation option which had such an appalling UI that it took me several minutes to figure out exactly what it was on about.

It also lacked a back button to allow me to go back and choose the "upgrade" install which wasn't really explained at all either.

/hates microsoft
( Captain V, Sun 7 Sep 2008, 16:24, 10 replies, latest was 16 years ago)

And now my macro is running uber slow
Need to work out how to write efficient macros in excel 07 now. Bah humbug!
( Captain V, Sun 7 Sep 2008, 16:42, Reply)

I can feel your frustration, Captain.
Is this any good?
openoffice.org-suite.com/
I've found it to be quite helpful as I had little Microsoft software on my laptop. However, I only do basic crap on mine at home.
( thealternativefact, Sun 7 Sep 2008, 16:52, Reply)

I've considered openoffice before
But it'd take me too long to learn how to do the kinds of things I do with excel with calc.

Hopefully it shouldn't take me too long to rework the code I've written to work more efficiently. Serves me right for working with so much data I suppose!
( Captain V, Sun 7 Sep 2008, 16:59, Reply)

Well look at this way
at least you're not moping around with nothing to do!
( thealternativefact, Sun 7 Sep 2008, 17:04, Reply)

That's very true
And it has prompted me to have to learn about an aspect of excel that I'd not previously used before and I love learning so that's good.
( Captain V, Sun 7 Sep 2008, 17:13, Reply)

eXcel macros
Just learn visual basic and write them properly yourself. It's really not that hard and very similar to fortran.
(Shippy likes linebreaks and doesn't care what you think, Mon 8 Sep 2008, 0:38, Reply)

That's what I do
Need to get my head around reading an entire array from the spreadsheet, working with it, creating additional arrays of the results then inputting those to the spreadsheet in one go.

It'd cut (off the top of my head) approximately 600,000 read/writes down to 1 read from the spreadsheet and 2 writes to it.

Until now I've not worked with large enough amounts of data to really worry about how often data is passed between VBA and excel but now it's becoming an issue. Ah well.
( Captain V, Mon 8 Sep 2008, 8:34, Reply)

ARGH!
Office 07 pisses me off something rotten.

The fact that they've decided to create a new document format doesn't surprise me, the fact that you can't open in it any other version of office does. It annoys me further that the converter is about 30mb, and is slow as shit to download.

However, I understand that you can change the default file type so that it saves as .doc rather that .docx.

What makes me want to scream is that IT NEVER BASTARD STAYS LIKE THAT!
( Agnostic Antichrist Baltimora, Mon 8 Sep 2008, 11:10, Reply)

personally
I prefer '07

the only thing is the default language keeps resetting to EN-US, despite me having EN-UK, and ES as the ONLY two used for spell-checking
(bamboozled Can hear you getting fatter, Mon 8 Sep 2008, 14:33, Reply)

I must admit
I do quite like (excel) 07 the more I use it. Don't like the charts at all though. Nowhere near as easy to use as the old charts. I'm sure I'll get the hang of them though.
( Captain V, Mon 8 Sep 2008, 15:09, Reply)