Sorry I couldn’t help it. From a KB article about automation add-in failures:
[How to load an Automation Addin]
In Microsoft Office Excel 2003 or in Microsoft Excel 2002, follow these steps:
a. On the Tools menu, point to Add-Ins, and then click Automation.
b. In the list, click TestAddIn.Class1, and then click OK.
c. In the Add-Ins dialog box, click OK.
In Microsoft Office Excel 2007, follow these steps:
a. Click the Microsoft Office Button, and then click Excel Options.
b. Click the Add-Ins tab.
c. In the Manage list, click Excel Add-ins, and then click Go.
d. In the Add-Ins dialog box, click Automation.
e. In the list, click TestAddin.Class1, and then click OK.
f. Click OK.
6 steps in 2007 compared to 3 in 2003 – thats progress!
If they ‘improve’ that UI much more in the next version it will be 12 steps, Office 14 will need an RSI health warning as part of the EULA. And possibly need to ship with your choice of spare mouse or trackpad.
I hope their documentation folks get paid by the word!
And btw creating the automation add-in refers to VB6!
[if you count the steps its more like 9 v 6 but that wouldn't be so funny]
cheers
Simon
Friday, 28th September, 2007 at 6:14 am |
I always said the Office 2007 fattened UI …er… Fluent
Sam
Friday, 28th September, 2007 at 6:57 am |
[...] Simon Murphy’s post on the inefficiency of loading automation add-ins in Excel 2007 touched a nerve. I’m wrapping up the help file for FlowBreeze 2.0, and I consistently find [...]
Friday, 28th September, 2007 at 11:39 am |
Efficient + Fluent = Effluent
“And possibly need to ship with your choice of spare mouse or trackpad.”
I joked in another forum about how the Office UI team was in cahoots with the Microsoft Hardware people. Great way to force people to buy more optical mice: wear them out.
Speaking of going backwards, if you use an Office 2003 shortcut, Alt-T-I, you can cut a lot of wasted dialogs out of the process to access the familiar old Add-Ins dialog.