Author Archives: dougaj4

Getting hard disk physical serial numbers

Posted on 21/11/2010 by dougaj4

There was a question at Eng-Tips about how to get the physical serial number of a hard disk (rather than the soft number, that is changed by a re-format): http://eng-tips.com/viewthread.cfm?qid=285948&page=1 A search found this discussion with the answer: http://thedailyreviewer.com/office/view/programmatically-obtain-the-hard-disks-serial-number-from-vba-101853101 (see answer … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 1 Comment

coffeescup a.k.a. lemonflower

Posted on 14/11/2010 by dougaj4

Browsing for anything new on You Tube I come across a cover of Anne Briggs’ “Go Your Way”.  Typical You Tube home produced standard, jerky out of sync video, dim lighting, adjust the controls before the song starts, yawn … … Continue reading →

Posted in Bach | Tagged , , | 20 Comments

Revision to CSpline2.xls

Posted on 11/11/2010 by dougaj4

It was recently reported to me that the cubic spline spreadsheet CSpline2.xls (posted here) was crashing on loading in Excel 2003.  It seems that the problem was with the ChartSpline function, and that there are no problems if this function is … Continue reading →

Posted in Drawing, Excel, Maths, UDFs, VBA | Tagged , , | 6 Comments

Danny Thompson & Zoe Rahman …

Posted on 10/11/2010 by dougaj4

… playing an instrumental version of Nick Drake’s “One of These Things First” this year at The Barbican in London. I think this is just amazing, wish I’d been there. And the original from Nick Drake:

Posted in Bach | Tagged , , | 1 Comment

Tool-tip tip

Posted on 10/11/2010 by dougaj4

Mike Woodhouse (Grumpy Old Programmer) recently posted a handy  little tip about tool-tips in the Visual Basic Editor. If you hover over a variable whilst de-bugging a VB routine, the current value of the variable is displayed as a tool-tip: but … Continue reading →

Posted in Excel, VBA | Tagged , , | 1 Comment