VBA

Well, aren't I just the clever clogs. I've finally managed to write my first macro completely from scratch in VBA. To explain. Normally if I want to write a macro I'll record one of me doing whatever the task is and then go into the code and edit it until it does exactly what I want. This means that I don't need to know to much of the object model as the code provided by the recording makes it fairly clear what I need to use. Unfortunately, Outlook doesn't allow you to record macros. I don't know why (maybe it's a security feature) but there you are. But I have a daily task which currently I accomplish by going the long(ish) way round that I really want to automate. So yesterday I decided "Right. I'm fed up with this I'm going to sit here and fiddle until I've automated it." So I looked at the object model in the help and the examples and sat down and fiddled and lo! I have now written a macro which actually automates my task and put the button on the toolbar. All by myself :) And I've finally worked out how you're supposed to use the debuggers in MS stuff, which I'd never got the hang of before - they're actually quite clever really :)

Security holes

Hmmm. Once again with the moral dilemma. We are not supposed to be able to check web mail from work. Because I've got my account from a nice obscure hosting company I can check mine. That’s not a problem (or at least I'm not concerned about it). But I have now discovered that there is a way into Yahoo mail from here. And (this is the worrying bit) it's not all that obscure. So, the question is, do I tell IT security?

I guess what this actually does is point up my elitism. I wouldn't consider giving them the heads up on my hosting company's web mail because the chances are pretty high that I'm the only one here who's using it and I know that I can be trusted not to run stupid attachments on my PC. And, at the very least the only people who are using it are likely to be similarly techy. But loads of plebs use Yahoo - do I trust them not to fuck our network up by running VB attachments? That's certainly the justification they give for blocking these sites in the first place - a vector for viruses. I seem to assume that most people just won't have enough tech common sense. Sadly, as last years infection of the bank with Code Red shows, I'm probably right.

(no subject)

Ok, I was going to not say this. I've resisted all week. Because, once again, I'm raging about something I can't change. But then this lunchtime it just got too much and I thought "Well if I can't vent in LJ where can I?" So, here it is.

( I couldn't care less that the Queen Mum is dead )

(no subject)

Damn. I'm high on dance music. Note to self: Playing Kylie (In your Eyes), then Puretones (Addicted to Bass) makes you twitchy but more productive.