I haven’t posted in a while, but circumstances being what they are at the day job, I feel like I just have to get this First Law down on this virtual paper. You see, I’ve been in IT a long time. Going on fifteen years. And right now, the company I work for is embarkingContinue reading “Scott’s First Law of Software Implementation”
Category Archives: Software
Excel Geeking: Removing All Empty Sheets using VBA
You ever need to go through a workbook you’re working on and delete a bunch of sheets that have nothing in them? Maybe you’re creating a new automated report that requires you to plunk down a large chunk of data in a new workbook, but when you create that new workbook, it creates it with “Sheet1”Continue reading “Excel Geeking: Removing All Empty Sheets using VBA”
Excel Geeking: Extracting Comments Using VBA
A couple of months ago a colleague moved into a new position at work and inherited a big ugly spreadsheet. Happens to the best of us, amiright? The biggest challenge with this spreadsheet is that the previous owner, who has since retired (and good for him!) didn’t update his status notes and comments in aContinue reading “Excel Geeking: Extracting Comments Using VBA”
Excel Geeking: Using Special Characters in ListObject Column Names in VBA
This is a short one, but a REALLY specific one. Recently (i.e., today) I was tinkering with some List Objects, a.k.a. “tables” in VBA. All I was trying to do was to clear the contents of a column. Easy enough. It looked something like this: No Excel love. It kept throwing me an error. Specifically, errorContinue reading “Excel Geeking: Using Special Characters in ListObject Column Names in VBA”
Excel Geeking: Extracting Outlook Address Book Information To Excel Using VBA
Yeah, I know there are a lot of posts out there about this already. So here’s another. Truth be told, when I first went searching for items on this topic, I couldn’t find what I was looking for. Granted, it’s not outside the realm of possibility that I simply suck when it comes to a decent GoogleContinue reading “Excel Geeking: Extracting Outlook Address Book Information To Excel Using VBA”
Excel Geeking: “That Command Cannot Be Used On Multiple Selections” Error On A Single Cell
UPDATE (18-FEB-2015): Remember this? Yeah, unfortunately I do too. I wish I could say that my update from September was the end of the conversation. Sadly, it wasn’t. I started getting this error again and there was no random PowerPivot data connection in my workbook. When I saw it pop up again, I was absolutelyContinue reading “Excel Geeking: “That Command Cannot Be Used On Multiple Selections” Error On A Single Cell”
MS Access Geeking: Giving Your Form’s Buttons A Nicer Place To Live
This one is for all the MS Access geeks out there who, like myself, are not intimately familiar with all of the super-secret methods the Builders Of Microsoft Templates use to get that high-class finished look. I searched online for a while trying to figure this one out until I found a solution buried inContinue reading “MS Access Geeking: Giving Your Form’s Buttons A Nicer Place To Live”
Happy International Keyboard Shortcut Day
Happy International Keyboard Shortcut Day. Never heard of it? Yeah, neither had it. That’s likely because Dick Kusleika over at Daily Dose of Excel made it up. Read more about it here. Basically, the idea is to use only your keyboard as much as possible between the time of 2:30 and 3:30 PM local on this,Continue reading “Happy International Keyboard Shortcut Day”
Excel Geeking: Unwinding a Crosstabbed Dataset
Sometimes you have to work with a data set that is not in a state conducive to, well, anything. I’m thinking specifically about crosstabbed data sets. More than once I’ve had to deal with a data set that looks like this: Oh, if only there were a way to unwind this file so that it wasContinue reading “Excel Geeking: Unwinding a Crosstabbed Dataset”
Excel Geeking – How I Control Releases of Excel Templates
In my current position, I manage the care and feeding of a type of planning system. The whole thing has been built in Excel, and presents more than a few challenges. Since I didn’t do the original construction, I inherited the application, and without being able to make major back-end changes, I’ve only been ableContinue reading “Excel Geeking – How I Control Releases of Excel Templates”
Scott C Lyerly 