excel - Open Local JSON file in VBA -

i have number of local json files trying open string using vba in order extract specific information them excel.

i have seen similar exercise work when files accessed http (using new.winhttp.winhttprequest), when i've tried adapt using file:/// prefix won't work.

is there different excel method can use access string content of json file?

cheers

chris

reading disk not adapt code reads url do.

you can load memory with;

dim hf integer: hf = freefile dim data string  open "c:\bla\bla.bla" input #hf     data = input$(lof(hf), #hf) close #hf  debug.? data 

there many results json parsing in vba.