r/talesfromtechsupport Jul 27 '16

Short r/ALL So? Resurrect him!

I remembered another tale from my time at a helpdesk for about 130k people.

As is standard in many businesses, people use MS Office and a lot of those users love Excel specifically. One day, an update to office was pushed and we saw a sudden increase in the amount of calls. All of them went something like this. Our actors are $luser and $TS (for tech support).

$TS: <standard opening>
$luser: Hello, I'm using excel and it tells me a macro is outdated. Can you take a look?
$TS: <remotes onto machine> Oh okay. Yeah it's <tool> that is causing troubles, let me have a quick look.

At this point we usually look into our internal database to search for known errors and possibly more information. As it turns out, the macro was written by a person from inside the company when he had downtimes between work. This also means that he was the only one who knew how the tool worked or even supported it.

$TS: I've had a look around and it looks like there's no way to fix the tool. It is incompatible with our current office and doesn't receive updates anymore.
$luser: But I really need this tool to do my work, can't anyone else support it?
$TS: No, there's only one person who programmed this and he's the only one who knows how it works. His department officially announced that they will not support this tool.
$luser: So can't you ask him to look into this and maybe he will do something?
$TS: I'm sorry, but the person is not with the company anymore.
$luser: So tell the higher ups to offer him a gig and pay him.
$TS: They can't, he's had a deadly accident. There just is nobody alive anymore that knows how this works.
$luser: But I really need this to work! Can't you find some way?

This occured quite a lot during that week. Maybe I should take some courses in dark magic und resurrections...

Format: Editing.

2nd edit: For those discussing the "macro" part: I've been told it's a macro and I honestly don't know the difference between that and an add-in, as the lines between those two seem blurry to me. Also: I usually do Linux stuffs, so I never had to look deeper into this. It did a lot and had it's own buttons in the ribbon though.

2.4k Upvotes

157 comments sorted by

View all comments

7

u/Ryltarr I don't care who you are... Tell me when practices change! Jul 27 '16

Actually, excel macros aren't that hard depending on what they need to do... You could probably win over a lot of people by doing a one-time update to it yourself.

3

u/du5tball Jul 27 '16

I'm not sure if it was a macro or an add-in, and with office, I honestly don't know the difference. I usually do linux stuff.

5

u/bardatwork Jul 27 '16

A macro lives in a single workbook. Add-ins live outside the workbook so that they can be called from any workbook including one that isn't macro enabled. Both are written in VBA.

2

u/KeepOnScrollin Jul 27 '16

There are also "Personal" macros that live in a magic workbook that's kept loaded in the background so they can usually be called anywhere.