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”
Tag Archives: development
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”
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”
Excel Geeking: Using VBA And ADO To Change Data to SharePoint Lists
I don’t get a ton of hits on this blog. But for the hits I do get, most them are focused on the Excel stuff. And of the Excel stuff, one of the most popular is Using VBA and ADO To Pull Data From SharePoint Lists. Because of this, I felt the need for aContinue reading “Excel Geeking: Using VBA And ADO To Change Data to SharePoint Lists”
Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists
I’ve been developing a SharePoint team site for my area which will house all kinds of information about the process and tools that I and my team support. I’ve been tinkering with the team site now for about two weeks. I’ll say this about SharePoint: moving around it is definitely not intuitive, and you canContinue reading “Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists”
VBA Geeking: How To Change The Color Of A Task Row In MS Project
Sorry about the two week absence. I was on vacation last week (as much of a vacation cleaning out a garage and painting a bedroom can be–more on that another day), and the week before I was crazy busy at work preparing to be out for a week. So, to celebrate being back, I thoughtContinue reading “VBA Geeking: How To Change The Color Of A Task Row In MS Project”
VBA Geeking: How To Correct An Error In MS Project Custom Ribbon Callbacks
First off, an apology. In trying to find the best way to post code, I’ve used a couple of different methods in my various posts, and if you’re trying to utilize the code, it can be a bit disjointed. So I apologize for that. I’m still trying to find the best way to post codeContinue reading “VBA Geeking: How To Correct An Error In MS Project Custom Ribbon Callbacks”
Excel Geeking: A Class Wrapper for Winzip
A couple of years ago I was involved in the implementation of a software system that required data files transferred to the hosted system via FTP. Each set of data required four different files to be bundled together in a compressed format. Most of the time, the data we needed could be pulled right outContinue reading “Excel Geeking: A Class Wrapper for Winzip”
Scott C Lyerly 