active-x-cant-create-objects
To automate Ruby via VBscript, JScript or VB.Net and for Ruby to communicate with MSOffice (via Exports.js) and for MSOffice to communicate with Ruby (via […]
Automation
Using VB Express for Scripting
The recommended version is now Visual Studio Express for Desktop. This can be downloaded from https://www.visualstudio.com/en-us/products/visual-studio-express-vs.aspx Microsoft is constantly changing the download point, so if […]
Auto-Generate a Blend File for Multi-Response
Despite our best efforts to get Triple-S established as the preferred format for survey data interchange between the collection system and Ruby, the SAV (or […]
Batch Processing by Script
We’ve had a few goes at the perfect approach to scripted reports, but I think that this is it. If anyone reckons they have a […]
Debug/Develop Scripts using If 1 = 2 and Exit Sub
A good way to temporarily remove large slabs of code within a subroutine is to fence it as if 1 = 2 then … code […]
SharpDevelop: An Alternative IDE to Visual Studio Express
A client recently asked about alternatives to VS Express for scripting Ruby jobs. I did a search on “VB.net free IDE” and got to here: […]
A Beginner’s Guide to Using VB for Ruby
I’m often asked for a quick’n’dirty tutorial on VB scripting. I’ve hunted the internet, but the contenders are either much too complicated for this purpose, […]