Here's how to get started with ScriptDB as a dead drop. For this example, I'll be instrumenting Integrating Excel with Maps and Earth to use a dead drop to pass data between Excel and the generated app. You should familiarize yourself with A VBA API for scriptDB, since we'll be using that API.
You'll need various modules and classes in your workbook. You can incorporate these into your own workbook automatically (How to update modules automatically in VBA) using
but for playing around with this example, just download googleMapping.xlsm from Downloads. The required libraries are also in cDataSet.xlsm.
To be able to access the correct scriptDB from Excel, various parameters and keys are needed. This only needs to be done once per user/PC combination. Since you may not want to share these, I recommend a separate workbook, but the public scriptDB credentials we are going to use for deadDrop playing are in googleMapping.xlsm, and look like this. You should execute this on the PC you are going to use to store the credentials in the PC registry under an entry called "messages". In future, we'll use that entry name to get handles to the scriptDb deadDrop.
For convenience, I've included this code in the template section of googleMapping.xlsm, and you can generate and execute it like this. If you are planning to execute from a web site rather than locally, then move the generated file there and execute it.
That's the preparation over.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated > Google Apps ScriptDB > ScriptDB as a dead drop >