Groups keyboard shortcuts have been updated

Dismiss

See shortcuts

Excel Liberation

Contact owners and managers

1–30 of 478

Welcome to Excel Liberation Forum. Please sign up and start participating. This is an open forum for topics related to the Excel Liberation site and blog

0 selected

12/29/17

Edit a Google Sheet line by line with VBA

I downloaded and implemented the code from http://ramblings.mcpher.com/Home/excelquirks/

unread,

Edit a Google Sheet line by line with VBA

I downloaded and implemented the code from http://ramblings.mcpher.com/Home/excelquirks/

12/29/17

blonde...@gmail.com, … Bruce Mcpherson17

7/4/19

sheetsAPI don't work

Thanks.im sure this will be useful for others Bruce. On Thu, Jul 4, 2019 at 11:30 AM 'Rich'

unread,

sheetsAPI don't work

Thanks.im sure this will be useful for others Bruce. On Thu, Jul 4, 2019 at 11:30 AM 'Rich'

7/4/19

wilson...@gmail.com

5/3/17

Sankey Diagrams - Columns

Hi, I've been using the excel to sankey program - fantastic tool. I was wondering if anyone could

unread,

Sankey Diagrams - Columns

Hi, I've been using the excel to sankey program - fantastic tool. I was wondering if anyone could

5/3/17

kevinng...@gmail.com

3/18/16

serialize function added backslash (\) to my value

Hi, I tried to .add a string "johnson, Kent <ken...@abc.com>;Hensman, Sean <sean.

unread,

serialize function added backslash (\) to my value

Hi, I tried to .add a string "johnson, Kent <ken...@abc.com>;Hensman, Sean <sean.

3/18/16

alsterwassser, Bruce Mcpherson2

11/4/14

How to draw a polygons or ellipse in Google Maps from Excel

One quick way to do it would be to mark spots on the map, and set them up the same flight path. that

unread,

How to draw a polygons or ellipse in Google Maps from Excel

One quick way to do it would be to mark spots on the map, and set them up the same flight path. that

11/4/14

Robert de Vries, … Familie Hug5

9/30/14

Json to excel from StatsWales website

Thanks both, I wanted the eventual tables to have the following columns: SCHOOL NAME | SCHOOL CODE |

unread,

Json to excel from StatsWales website

Thanks both, I wanted the eventual tables to have the following columns: SCHOOL NAME | SCHOOL CODE |

9/30/14

Az, Bruce Mcpherson6

9/18/14

json API to excel (array)

That worked very well. Thank you very much! On Monday, September 15, 2014 7:49:26 AM UTC-4, bruce

unread,

json API to excel (array)

That worked very well. Thank you very much! On Monday, September 15, 2014 7:49:26 AM UTC-4, bruce

9/18/14

bryant...@gmail.com, bruce13

8/27/14

Json to Excel from Rest endpoint

I think the issue that I am experiencing is that the url of the json on the company's server is

unread,

Json to Excel from Rest endpoint

I think the issue that I am experiencing is that the url of the json on the company's server is

8/27/14

al syntax, bruce2

6/16/14

Bing or Google Map in Excel - Customize

have you tried to follow this? http://ramblings.mcpher.com/Home/excelquirks/snippets/steps/markers On

unread,

Bing or Google Map in Excel - Customize

have you tried to follow this? http://ramblings.mcpher.com/Home/excelquirks/snippets/steps/markers On

6/16/14

Gustav Gans, Bruce Mcpherson2

4/17/14

parseCom. Error 401

nice catch - thank you .. i'll check it out On 17 April 2014 00:49, Gustav Gans <hugfamily@

unread,

parseCom. Error 401

nice catch - thank you .. i'll check it out On 17 April 2014 00:49, Gustav Gans <hugfamily@

4/17/14

4/14/14

Seeking some 'Getting Started' help for Data Liberation Lib

Inviting folks who've mastered Mr. McPher's utilities to a small bit of paid orientation and

unread,

Seeking some 'Getting Started' help for Data Liberation Lib

Inviting folks who've mastered Mr. McPher's utilities to a small bit of paid orientation and

4/14/14

sean.v...@gmail.com, Bruce Mcpherson2

3/26/14

Power Query provides rest api access

Hi - actually I don't know aything about power query. I do have a place for guest postings if you

unread,

Power Query provides rest api access

Hi - actually I don't know aything about power query. I do have a place for guest postings if you

3/26/14

stu.mc...@gmail.com, Bruce Mcpherson3

3/19/14

populateJSON acting very slowly...

Perfect, Thanks Bruce. Here is my whole solution in case others want to use it: Public Sub

unread,

populateJSON acting very slowly...

Perfect, Thanks Bruce. Here is my whole solution in case others want to use it: Public Sub

3/19/14

heckle...@gmail.com, Bruce Mcpherson8

2/20/14

VBA+JSON+Excel+Frustration^2

The following code works: Private Function testLocation() Dim cb As cBrowser, ds As cDataSet, job As

unread,

VBA+JSON+Excel+Frustration^2

The following code works: Private Function testLocation() Dim cb As cBrowser, ds As cDataSet, job As

2/20/14

Richard Case, Bruce Mcpherson8

11/19/13

Convert JSON from hierarchical structure to flat structure?

bPopulate should be false, since you are going to populate the sheet directly.. querycanbeblank is

unread,

Convert JSON from hierarchical structure to flat structure?

bPopulate should be false, since you are going to populate the sheet directly.. querycanbeblank is

11/19/13

Brad, Bruce Mcpherson3

11/13/13

Displaying the Google Map within the Excel Spreadsheet

Great I will try this and let you know how I get on! Thanks On Tuesday, 12 November 2013 11:20:03 UTC

unread,

Displaying the Google Map within the Excel Spreadsheet

Great I will try this and let you know how I get on! Thanks On Tuesday, 12 November 2013 11:20:03 UTC

11/13/13

David Scott Stokes, Bruce McPherson3

11/4/13

Parsing XML with branches to a single row in Excel

Hi Bruce, There was only a duplicate name for a moment as I copied the original down, changed the

unread,

Parsing XML with branches to a single row in Excel

Hi Bruce, There was only a duplicate name for a moment as I copied the original down, changed the

11/4/13

David Scott Stokes, Bruce Mcpherson7

10/31/13

REST GET returns XML rather than JSON to store in the target sheet.

Thank you Bruce. :-) Regards David SCOTT STOKES Chartered Accountant FCA PMP david.scott.stokes@inman

unread,

REST GET returns XML rather than JSON to store in the target sheet.

Thank you Bruce. :-) Regards David SCOTT STOKES Chartered Accountant FCA PMP david.scott.stokes@inman

10/31/13

Don Nalezyty, Bruce Mcpherson4

10/31/13

Rest, Authentication & Cookies from within Excel

Don you can encourage POST to not complain about certificates with code that looks like this (see

unread,

Rest, Authentication & Cookies from within Excel

Don you can encourage POST to not complain about certificates with code that looks like this (see

10/31/13

Jason Turner, … Bruce McPherson8

2/21/14

Need help creating an object model

Here's how you can hide persistent data somewhere In a spreadsheet. http://ramblings.mcpher.com/

unread,

Need help creating an object model

Here's how you can hide persistent data somewhere In a spreadsheet. http://ramblings.mcpher.com/

2/21/14

David Scott Stokes, Bruce Mcpherson4

10/15/13

generalQuery to site requiring user and password - code help needed

Hi Bruce, It works. :-) This is brilliant. Thank you very much. With your help, I now realise that

unread,

generalQuery to site requiring user and password - code help needed

Hi Bruce, It works. :-) This is brilliant. Thank you very much. With your help, I now realise that

10/15/13

Jason Turner, … Bill Foote6

10/11/13

Newbie, struggling with ROADMAP example, MsgBox "No Data to Process"

Thank you all very much for the quick reply. I found that in the code I posted above. If I input the

unread,

Newbie, struggling with ROADMAP example, MsgBox "No Data to Process"

Thank you all very much for the quick reply. I found that in the code I posted above. If I input the

10/11/13

pit...@gmail.com, Bruce Mcpherson3

10/15/13

Thank you for the code. It works fine :-) 2013/10/8 Bruce Mcpherson <br...@mcpher.com>

unread,

Thank you for the code. It works fine :-) 2013/10/8 Bruce Mcpherson <br...@mcpher.com>

10/15/13

Robert Cowham, Bruce Mcpherson5

10/3/13

How to get standalone nodes

Thanks - that fixed it. Appreciated! On Thursday, 3 October 2013 16:39:43 UTC+1, bruce wrote: the

unread,

How to get standalone nodes

Thanks - that fixed it. Appreciated! On Thursday, 3 October 2013 16:39:43 UTC+1, bruce wrote: the

10/3/13

ricard...@gmail.com, Bruce Mcpherson3

9/16/13

Querytable - Post Method - Encode arguments string

Tanks for the tip, Bruce. I'll try it. ------------------------- Em quarta-feira, 11 de setembro

unread,

Querytable - Post Method - Encode arguments string

Tanks for the tip, Bruce. I'll try it. ------------------------- Em quarta-feira, 11 de setembro

9/16/13

Keith Rossman, Bruce McPherson4

8/28/13

cJobject output

Yes there is both an append and a merge method. But the best way is to pass the cjobject as an

unread,

cJobject output

Yes there is both an append and a merge method. But the best way is to pass the cjobject as an

8/28/13

Prerna Sampat, … sachin....@gmail.com7

10/14/13

Using Bing Maps API as default and falling back to Google Maps API

Thanks Bruce, will do accordinlgy. Great help. On Friday, October 11, 2013 7:06:48 PM UTC+5:30, bruce

unread,

Using Bing Maps API as default and falling back to Google Maps API

Thanks Bruce, will do accordinlgy. Great help. On Friday, October 11, 2013 7:06:48 PM UTC+5:30, bruce

10/14/13

SoccerGuy, Bruce Mcpherson15

2/12/14

Dynamic Schedule Generator

Hi Bruce, How are you? I gave it a try but got very confused trying to understand. My difficulty is

unread,

Dynamic Schedule Generator

Hi Bruce, How are you? I gave it a try but got very confused trying to understand. My difficulty is

2/12/14

acorps, Bruce McPherson2

7/14/13

googleVis - Motion Charts

I believe it relies on flash. Did you follow the instructions about trusted flash locations? Sent

unread,

googleVis - Motion Charts

I believe it relies on flash. Did you follow the instructions about trusted flash locations? Sent

7/14/13

welle...@hotmail.com, Bruce Mcpherson3

6/12/13

How to remove the blue overlay on Google Map?

Hi Bruce, attached is the Macro-enabled workbook for you to look at. It's the first sheet that

unread,

How to remove the blue overlay on Google Map?

Hi Bruce, attached is the Macro-enabled workbook for you to look at. It's the first sheet that

6/12/13

Search

Clear search

Close search

Google apps

Main menu