Here's a VBA app that uses Database abstraction with google apps script via the DataHandler library. You need to download the latest version of the dbAbstraction.xlsm workbook from Downloads. Note that a Google Script Webapp is providing the gateway from your VBA app to each of these database back ends.
It's made up of these components
Let's get into the code - it's self explanatory, but How to use cJobject and How to use cDataSet will explain the VBA libraries in use here.
Using this you can read, write and query a variety of databases directly from your VBA code. This simple example does all of the following
Here's the code. It's in the dbAbstraction.xlsm workbook, which also contains all the libraries you'll need. see Downloads.
and here are the results in their respective homes. Excel (from Driver Import.io) [ { "key": "up1398763280434", "data": { "skills": "Intellect Cyperpathic Link Strenght and durability Energy repulsors Missiles", "species": "Human", "origin": "Earth", "photo": "http://cdn.import.io/integrate/img/iron-man.png", "alter_egos": "Anthony Edward \"Tony\" Stark", "name": "Iron Man", "more_info": "http://en.wikipedia.org/wiki/Iron_Man", "photo__source": "img/iron-man.png", "more_info__text": "Iron Man on Wikipedia", "more_info__title": "Wikipedia", "photo__alt": "Iron Man using repulsors", "photo__title": "Iron Man" } }, { "key": "ih1398763280434", "data": { "skills": "Intellect Sheild-fighting Hyperkinetic senses Field commanding", "species": "Human", "origin": "Earth", "photo": "http://cdn.import.io/integrate/img/captain-america.png", "alter_egos": "Steven \"Steve\" Rogers", "name": "Captain America", "more_info": "http://en.wikipedia.org/wiki/Captain_America", "photo__source": "img/captain-america.png", "more_info__text": "Captain America on Wikipedia", "more_info__title": "Wikipedia", "photo__alt": "Captain America looking forlorn", "photo__title": "Captain America" } }, { "key": "jj1398763280435", "data": { "skills": "Super strength Speed and endurance Anger empowerment", "species": "Human", "origin": "Earth", "photo": "http://cdn.import.io/integrate/img/hulk.png", "alter_egos": "Dr Robert Bruce Banner", "name": "Hulk", "more_info": "http://en.wikipedia.org/wiki/Hulk_(comics)", "photo__source": "img/hulk.png", "more_info__text": "Hulk on Wikipedia", "more_info__title": "Wikipedia", "photo__alt": "Hulk looking angry and being shot at", "photo__title": "Hulk" } }, { "key": "qg1398763280435", "data": { "skills": "Durability and longevity Strength Dimensional transportation Electric manipulation Weather manipulation Big hammer", "species": "Asgardian", "origin": "Asgard", "photo": "http://cdn.import.io/integrate/img/thor.png", "alter_egos": "Thor Odinson", "name": "Thor", "more_info": "http://en.wikipedia.org/wiki/Thor_(Marvel_Comics)", "photo__source": "img/thor.png", "more_info__text": "Thor on Wikipedia", "more_info__title": "Wikipedia", "photo__alt": "Thor looking at destruction", "photo__title": "Thor" } }, { "key": "jk1398763280435", "data": { "skills": "Slowed aging Enhanced immune system Superior athletic condition Hand to hand combat training Hypnosis Psychological defences", "species": "Human", "origin": "Earth", "photo": "http://cdn.import.io/integrate/img/black-widow.png", "alter_egos": "Natalia Alianovna Romanova Natasha Romanova", "name": "Black Widow", "more_info": "http://en.wikipedia.org/wiki/Black_Widow_(Natalia_Romanova)", "photo__source": "img/black-widow.png", "more_info__text": "Black Widow on Wikipedia", "more_info__title": "Wikipedia", "photo__alt": "Black Widow in a martial-arts fighting pose", "photo__title": "Black Widow" } }, { "key": "by1398763280435", "data": { "skills": "Grandmaster archer Trick arrows Arm strength Swordsman", "species": "Human", "origin": "Earth", "photo": "http://cdn.import.io/integrate/img/hawkeye.png", "alter_egos": "Clinton Francis \"Clint\" Barton", "name": "Hawkeye", "more_info": "http://en.wikipedia.org/wiki/Hawkeye_(comics)", "photo__source": "img/hawkeye.png", "more_info__text": "Hawkeye on Wikipedia", "more_info__title": "Wikipedia", "photo__alt": "Hawkeye preparing to fire an arrow", "photo__title": "Hawkeye" } } ] DriverSheet [ { "siloId": "excelDemo", "data": { "skills": "Grandmaster archer Trick arrows Arm strength Swordsman", "species": "Human", "more_info__text": "Hawkeye on Wikipedia", "origin": "Earth", "photo__alt": "Hawkeye preparing to fire an arrow", "photo__title": "Hawkeye", "photo": "http://cdn.import.io/integrate/img/hawkeye.png", "alter_egos": "Clinton Francis \"Clint\" Barton", "more_info__title": "Wikipedia", "name": "Hawkeye", "more_info": "http://en.wikipedia.org/wiki/Hawkeye_(comics)", "photo__source": "img/hawkeye.png" } }, { "siloId": "excelDemo", "data": { "skills": "Intellect Sheild-fighting Hyperkinetic senses Field commanding", "species": "Human", "more_info__text": "Captain America on Wikipedia", "origin": "Earth", "photo__alt": "Captain America looking forlorn", "photo__title": "Captain America", "photo": "http://cdn.import.io/integrate/img/captain-america.png", "alter_egos": "Steven \"Steve\" Rogers", "more_info__title": "Wikipedia", "name": "Captain America", "more_info": "http://en.wikipedia.org/wiki/Captain_America", "photo__source": "img/captain-america.png" } }, { "siloId": "excelDemo", "data": { "skills": "Slowed aging Enhanced immune system Superior athletic condition Hand to hand combat training Hypnosis Psychological defences", "species": "Human", "more_info__text": "Black Widow on Wikipedia", "origin": "Earth", "photo__alt": "Black Widow in a martial-arts fighting pose", "photo__title": "Black Widow", "photo": "http://cdn.import.io/integrate/img/black-widow.png", "alter_egos": "Natalia Alianovna Romanova Natasha Romanova", "more_info__title": "Wikipedia", "name": "Black Widow", "more_info": "http://en.wikipedia.org/wiki/Black_Widow_(Natalia_Romanova)", "photo__source": "img/black-widow.png" } }, { "siloId": "excelDemo", "data": { "skills": "Super strength Speed and endurance Anger empowerment", "species": "Human", "more_info__text": "Hulk on Wikipedia", "origin": "Earth", "photo__alt": "Hulk looking angry and being shot at", "photo__title": "Hulk", "photo": "http://cdn.import.io/integrate/img/hulk.png", "alter_egos": "Dr Robert Bruce Banner", "more_info__title": "Wikipedia", "name": "Hulk", "more_info": "http://en.wikipedia.org/wiki/Hulk_(comics)", "photo__source": "img/hulk.png" } }, { "siloId": "excelDemo", "data": { "skills": "Intellect Cyperpathic Link Strenght and durability Energy repulsors Missiles", "species": "Human", "more_info__text": "Iron Man on Wikipedia", "origin": "Earth", "photo__alt": "Iron Man using repulsors", "photo__title": "Iron Man", "photo": "http://cdn.import.io/integrate/img/iron-man.png", "alter_egos": "Anthony Edward \"Tony\" Stark", "more_info__title": "Wikipedia", "name": "Iron Man", "more_info": "http://en.wikipedia.org/wiki/Iron_Man", "photo__source": "img/iron-man.png" } }, { "siloId": "excelDemo", "data": { "skills": "Durability and longevity Strength Dimensional transportation Electric manipulation Weather manipulation Big hammer", "species": "Asgardian", "more_info__text": "Thor on Wikipedia", "origin": "Asgard", "photo__alt": "Thor looking at destruction", "photo__title": "Thor", "photo": "http://cdn.import.io/integrate/img/thor.png", "alter_egos": "Thor Odinson", "more_info__title": "Wikipedia", "name": "Thor", "more_info": "http://en.wikipedia.org/wiki/Thor_(Marvel_Comics)", "photo__source": "img/thor.png" } } ] |
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Apps built with data abstraction >