Showing posts with label VBA. Show all posts
Showing posts with label VBA. Show all posts

Friday, 14 August 2015

Email, and other dangers

We recently had a spate of emails arrive at work, some claiming to be from RBS and some from Santander.


My curiosity got the better of me, so I saved the attached Word document, brought it home, and studied it on a Linux machine.


It turned out to be rather easy to pull apart, but rather difficult to piece together and understand.

Saturday, 1 November 2014

WMI, VB.classic & Excel

On this blog, posts about Microsoft software are as rare as Rocking Horse sh manure. But I have to get my hands dirty for a few hours each week, in my part-time network support job.


Although VB.classic (aka VB6) was replaced many years ago by VB.net, it lives on in the form of VBA (Visual Basic for Applications).


And if I need to gather information about networked Windows computers, I like to write VB code within Excel, and draw on the power of WMI (Windows Management Instrumentation).