Constructing Custom CRMs with Microsoft VBA ♦ We recently published a handful of blog posts centered around Microsoft VBA (Visual Basic for Applications, aka macros) and how the various Microsoft desktop productivity applications that make up Microsoft Office can use this code to get the maximum power and ease of use out of the […]
Read More
Excel VBA
Should Your Organization Integrate Microsoft Excel and Microsoft SQL Server To Enhance Performance From small Data To BIG Data To HUGE Data – MS Excel/SQL Server Solutions This post picks up on “The Integration & Automation Series” of posts, from where we left off on our last post, Should you integrate Microsoft Excel […]
Read MoreShould You Integrate Microsoft Excel and Access From Small Data To BIG Data – This Is Your Beginner Solution So here is the scenario: Your medium sized business has been using Microsoft Excel to manage your firm’s finances via a series of linked Excel workbooks for years. The problem is this, over the […]
Read MoreHow to send an Excel file using Microsoft Outlook This is our second post on this subject (Click here to see the first, on our sister site, ExcelHints.Com). This post takes the Microsoft Excel VBA/Macro/code that Jacob (Microsoft Excel MVP) wrote up a notch in complexity from the first post (v1.0). This version of the […]
Read More