How to Create Your Own Web Service with Google Apps Script and Call it from Excel VBA

Ever needed to perform some Web task in service of your Excel VBA application? You can write your own web-service to do whatever you need * Popular use cases: access Google Sheets, Docs, Presentations, email and calendar from your Excel application!

Calling Web-services from Excel VBA

As I thoroughly explain and demonstrate in my online course: Beyond Excel Boundaries with VBA: Office, Files and Internet, you can send any HTTP request over an Internet connection from VBA using the WinHttp service library. Here’s a code snippet to send a request to some URL:

    Dim...

Continue Reading...

Google Spreadsheets vs. Microsoft Excel: What Should You Choose?

You know an electronic spreadsheet is the right tool for your need, but you’re not sure which of the available products to choose. Two prominent options are suggested: Google Spreadsheets and Microsoft Excel. Let’s make it easier for you

First, let’s consider your requirements. The following list will help us frame the discussion:

  • Do you need multiple users to concurrently work on the solution, or can one person at a time exclusively work on it?
  • Do you need pixel-perfect visual design with wide flexibility over fonts, colors, forms design etc.?
  • Does the solution needs to...
Continue Reading...
Close

50% Complete

Two Step

Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!