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

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

edward...@gmail.com, Bruce Mcpherson2

9/30/15

advice on json classes for newby

Send me and snip of the data and what the excel columns should look like in a workbook and I'll

unread,

advice on json classes for newby

Send me and snip of the data and what the excel columns should look like in a workbook and I'll

9/30/15

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

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

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

persona...@gmail.com, Bruce Mcpherson3

10/15/13

vba google spreadsheet httpGET, Authorization

thank your for your answer!!! I will try . вторник, 15 октября 2013 г., 16:25:42 UTC+3 пользователь

unread,

vba google spreadsheet httpGET, Authorization

thank your for your answer!!! I will try . вторник, 15 октября 2013 г., 16:25:42 UTC+3 пользователь

10/15/13

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

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

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

paul.w...@gmail.com, Bruce McPherson2

8/24/13

Interactive Time Series Graphic

Actually there are a number of vizualizations on the site .. Do a search For d3 on ramblings.mcpher.

unread,

Interactive Time Series Graphic

Actually there are a number of vizualizations on the site .. Do a search For d3 on ramblings.mcpher.

8/24/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

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

.René Teinze, … Bruce Mcpherson4

8/20/13

Parse JSON into Array in VBA

This site is really for VBA developers, although implementing something like this is rather

unread,

Parse JSON into Array in VBA

This site is really for VBA developers, although implementing something like this is rather

8/20/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

merchant...@gmail.com, Bruce Mcpherson4

5/9/13

1st attempt using cDataSet's excel pull of REST services - run time error

i guess.. Excel would use IE.. which browser did you try it in? are you at work (is there a proxy) ..

unread,

1st attempt using cDataSet's excel pull of REST services - run time error

i guess.. Excel would use IE.. which browser did you try it in? are you at work (is there a proxy) ..

5/9/13

3/25/13

New parse and stringify for cJobject

If you have been using cJobject for working with json and VBA you'll be used to this... to create

unread,

New parse and stringify for cJobject

If you have been using cJobject for working with json and VBA you'll be used to this... to create

3/25/13

finc...@gmail.com, Bruce McPherson3

3/5/13

OAuth 2 Authentication?

I was afraid you'd say that! Thanks for a point in the right direction at the very least. I'm

unread,

OAuth 2 Authentication?

I was afraid you'd say that! Thanks for a point in the right direction at the very least. I'm

3/5/13

artforart artforart

3/2/13

an automation for copy paste, added new row (macro)

Hello I have attached file I want to automated a some step (tab table Z) Thus, for example, that in X

unread,

an automation for copy paste, added new row (macro)

Hello I have attached file I want to automated a some step (tab table Z) Thus, for example, that in X

3/2/13

Oscar Martinez, Bruce Mcpherson9

3/5/13

Parse JSON Response from Google Analytics API V3

This data comes back as table shaped, with self defining columns and rows. Most rest queries have the

unread,

Parse JSON Response from Google Analytics API V3

This data comes back as table shaped, with self defining columns and rows. Most rest queries have the

3/5/13

Search

Clear search

Close search

Google apps

Main menu