Open Local JSON file in VBA

Question

I have a number of local JSON files which I am trying to open as a string using VBA in order to extract specific information from them into Excel.

I have seen a similar exercise work when the files are accessed by HTTP (using New.WinHTTP.WinHTTPRequest), however when I've tried to adapt this using a FILE:/// prefix it won't work.

Is there a different Excel method I can use to access the string content of the JSON file?

Cheers

Chris

Community · Accepted Answer · 2017-05-23 11:50:10Z

3

Reading from disk is not really something you would adapt code that reads from a url to do.

You can load it into memory with;

dim hf As integer: hf = freefile
dim data as string

open "c:\bla\bla.bla" for input as #hf
    data = input$(LOF(hf), #hf)
close #hf

debug.? data

There are many results for JSON parsing in vba.

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered May 21, 2013 at 14:47

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Open Local JSON file in VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related