No Picture
From VBA to Google Apps Script

How to create javaScript like objects in VBA

In javaScript, everything is an object. Classes don’t really exist  because they don’t have to. To create an class like structure, you just do something like this

  Then you can access employee.id etc […]

No Picture
Javascript

Using JScript inside VBA

Those of you that read this blog, and the ramblings site, will know that the topic content is about equally split between VBA and javaScript. Until today, I had no idea that there was a […]

No Picture
Apps Script & Java Script

Google Apps javascript timer

If you are working with Google Apps Script, one of your priorities is definitely going to be a simple timer. Everything takes longer than you are used to, and you have to be very careful […]

No Picture
Microsoft Office & VBA

OpenCorporate data Excel REST query

I got this idea from Tony Hirst’s great blog. The OpenCorporates API gives rich information many companies. Using Google Refine to reconcile, it cleans up many sources of data to a queryable datasource. So here […]

No Picture
Apps Script & Java Script

Google Apps Script Color Ramp

For those of you that have been following VBA to Google Apps Script, here is another one. This time, it’s a conversion of the Excel color ramp library. You can download the code for and […]

No Picture
Visualization

How to use the Excel Roadmapper

Excel Roadmapper from simple table data Some time ago, I showed how to develop a VBA roadmapper on the ramblings website. I’ve noticed that most of my visitors to that topic simply download the finished workbook […]

No Picture
REST API

rest library for Excel

Eliminating repetitive coding of Excel web service integration I find myself writing more and more web service to Excel integrations. Here are just a few examples of webservice-Excel integrations from the excel ramblings site. I […]

No Picture
VBA

How to use cDataSet

Excel Data Manipulation Classes I notice from Google Analytics the the cDataSet pages are by far the most popular on the site. These classes are used throughout all the projects on the site, and are […]

No Picture
Integrating Excel with Maps and Earth

Getting data from Google Maps to Excel

Mapping visualization layers from Excel The Google Maps API is a wonderful thing, allowing you to convert an unstructured and incomplete address and get back a whole bunch of structured and mapping data. Google is […]

No Picture
No category

Getting Started Series

Looking at Google Analytics Data for my site, I notice that there are 2 distinct populations. Those that look and read through a project article (5-10 minutes) and those that stay a few seconds on […]

No Picture
Json

Dynamic forms and jSon

Following previous developments on hiding data in excel objects, Excel jSon conversion and dynamic forms I figured it was time to combine all these threads, and have implemented all that as an integrated solution as […]

No Picture
Microsoft Office & VBA

Abstracting Excel Data

Classes for Excel Data Abstraction In a number of articles and topics on my website i have referred to a collection of classes that I generally use to abstract Excel physical location from the data contents. […]

No Picture
From VBA to Google Apps Script

Migrating to Google Docs

Ive been using Google Docs as well as Excel for a while now, and certainly Excel is more comfortable a user experience. However it’s clear that Google Docs offer a great opportunity to offer services […]

No Picture
Json

JSON deserializer

Completing the JSON deserializer/serializer I was missing being able to deal with arrays and could only deal with strings in the first version of this, but have finally figured out how to deal with this. […]

No Picture
No category

Topics under consideration

What next Thinking about what to work on next for the Excel Ramblings site, I wondered how I could pull together the work on JSON along with google visualization serialization to open up access to […]