Tag Archives: sql

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”

Excel Geeking: My Picks For Getting Started With Programming Excel

I’ve fielded this question a couple of times, so I thought I’d give to formal list here. These are the books I’ve used (and continue to) to get started with VBA/Excel programming (among other things). I also list the sites I visit regularly when I feel like expanding my Excel/VBA knowledge. BOOKS Excel 2010 PowerContinue reading “Excel Geeking: My Picks For Getting Started With Programming Excel”

Excel Geeking: A Question For Other Excel Geeks

Okay, this one is a bit out on a limb, since I don’t have a lot of followers, and expect most of them follow me for the writing or running posts, but here goes. I have a question for my fellow Excel geeks and gurus regarding development and design. Anybody with thoughts or opinions isContinue reading “Excel Geeking: A Question For Other Excel Geeks”