To do that I need to extend the spreadsheet. Since the spreadsheet already contains all of the contact info for the players’ parents, it would be great if I could just send SMS messages to the parents for things like canceled practices and game reminders right from within Excel. To keep track of the kids on the team, their parents and their contact information, I’ve created a new spreadsheet in Excel. Let’s pretend for a moment that I am the coach for a youth soccer team. Its trivial to create a new spreadsheet, type in your column headers and start making lists of stuff, so let’s use that scenario to demonstrate how easy it is to use VBA to interact with the Twilio API. One of the most common uses for Excel as a simple flat database. In this post I’ll show you how you can use VBA to extend both Excel and Access, letting you send SMS messages and make phone calls using the Twilio API right from inside those apps. Extending Office using VBA is popular because it is approachable by non-developers, easy to learn, and offers a way to quickly to add custom logic to Office applications. The applications have won this honored place in the hearts and minds of business workers in part because both applications are highly customizable through multiple means, one of which is by creating custom logic using Visual Basic for Applications (VBA), an implementation of the venerable Visual Basic language. Excel alone has been know to power the financial models of many businesses, and even entire countries. Well today that changes.įor better or worse, Microsoft Excel and Access are the backbone that power many organizational processes in companies big and small. And even though these two pieces of software have thousands of features, to date apparently no one at Microsoft has ever thought to put a phone in them. If you’ve used Windows like I have for the last 20 years, likely some of the most familiar pieces of software for you are Excel and Access.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |