February 9, 2012
During your work week, there are probably lots of times that you find yourself copying and pasting information from Excel into Word, or the other way around. This is how people often produce written reports based on data that’s accumulated and updated in an Excel spreadsheet. In this article, I’m going to dive a little more into the background VBA scripting that allows you to actually program connections between data in Excel and Word.
February 8, 2012
In the past, I’ve used email a whole lot in my batch jobs and other automated scripts, just like I’ve described in past articles. These are great for those times when you have a script that’s monitoring the health of a computer or the status of a specific process, but what if you want to automate sending emails from within Office products like Word or Excel?
December 14, 2011
When you really stop to think about it, an Internet browser in its simplest form isn’t really that impressive an application. I mean, yes, the Internet is amazing by anyone’s standards. The concept of linking so many of the world’s computers and mobile devices within this massive network, that is epic. But the concept of transferring a text file with special code in it onto a computer screen is not really a big deal.
October 28, 2011
There are a lot of fun pranks you can play on your friends with a computer. You’ve probably seen all of those creepy YouTube videos that people forward to each other for a good scare. Not long ago, Justin covered a few really funny ways to prank your parents with a computer too. All of those ideas are fun, but this year, how about creeping out your friends a bit with your very own programming skill?
May 31, 2009
For the first few years of my engineering career, I spent a lot of time writing Visual Basic based GUI applications for automated factory machines. These were the sort of VB applications that were very difficult to test, because for the most part the users consisted of moderately educated folks who had a hard time [...]
February 23, 2009
Most programmers are not just desktop programmers, web programmers or scripting gurus – they are often all of the above. Over time, most software developers find that it’s much easier to re-use code components than it is to recreate the wheel every time you write an application. Over time, these developers typically archive a library of [...]
