Excel VBA to remove duplicates and merge cells

Excel Automation for Data Analysts

Should you learn VBA? Note: A very simple sample file and code can be downloaded just above the video. A lot of “real” programmers dismiss VBA and Visual-basic in general. This is short-sighted for a number of reasons. Building solutions should be about effective solutions, not a myopic focus on the “most powerful tool.” When […]

What is server virtualization and why do you care?

Let’s start with the, “Why do you care?” question. Short answer: You don’t! You’re a business owner or manager, not a computer tech/system engineer. But… you might care, if you knew a little bit about it. And by that I mean, knowing what it is and more importantly, how it benefits the business using it. […]

Project and Collaboration Tools rundown – G Suite, Asana, Glip, Slack, and more

A friend and business coach, Bill Hart, asked the following question on Facebook: “Q: how do you manage your calendar, tasks and projects?“ In the future I’ll write a bit more about how your responses to online questions or emails you send can be turned into content for your social media. This is one of […]

cyber security advice

CYBER SECURITY BASICS – aka: The advice I know you’ll ignore

Summary: I provide a summary of some things you SHOULD do to improve your digital security. I then explain each in a little detail. Then, I admit that most people will ignore the advice. But.. here you go. We want security but not really Most people freak out about things like Facebook privacy settings and […]

Is your SAGE 50 Accounting too slow? Virtualization and Terminal Server

Technologies Sage 50 Accounting 2017 & 2018 Windows 2016 Hyper-V Windows 2016 Remote Desktop Server (Terminal Server) Dell Poweredge T330 Server Sage 50 Performance Sage has performance issues going back to its Peachtree roots. It is inefficient on a network and has poor utilities for purging and compressing data. My client was at their wits […]

Parsing Quickbooks Customer (CustomerRet) Response using XML (DOMDocument)

As I indicated in my Quicbbooks Part 1 of never post, I would post some Microsoft Access and other Quickbooks source code and blog entries, rather than do a more detailed step by step explanation. I hope this is helpful. Quick Explanation You can parse Quickbooks response using a ICustomerRetList – and I may post that […]

VBA Solutions - webpage scripting msxml

VBA solution: Scraping website information using MSXML, HTMLDocument, and getElementsByClassName

Summary An explanation of how to retrieve/scrape website data using MSXML and HTMLDocument but not using the InternetExplorer Application Object. The problem with the InternetExplorer.Application object I have a few blog entries demonstrating how to get web site data using InternetExplorer and the HTMLDocument object. However, there are a few problems with this: Microsoft is […]

Microsoft Access and Excel programming in Los Angeles

Quickbooks SDK iAddCheck using VBA. Add a check from Excel or Access

Someone reading my part 1 of ??? tutorial on Quickbooks – sorry.. read the notes. 😉  – was struggling to find how to add checks. I wrote them this morning about what to look for in the On Screen Reference OSR for the Quickbooks SDK. iCheckAdd Under the Onscreen Reference, there is a iCheckAdd message. […]

Campus Mesh WiFi using Sonicwall, Ubiquiti, and Open-Mesh (network integration)

Overview Our client, an RV resort, needs a robust and scaleable WiFi network for guests. Technologies/Vendors SONICWALL Open Mesh Ubiquiti   The Challenge A family of four can easily be responsible for 7 to 10 WiFi connections: 1 smart TV 2 laptops 1 tablet 4 smart phones 8 connections These connections are likely streaming Netflix, […]