Avatar of centralmike

asked on 

Error Importing JSON file into excel

I can't figure out how to clear a type mismatch error message importing a json file into excel.  I can import through the excel "Data" from web menu with no problem.  When I try to insert json through code I keep getting type mismatch 13 run time error.  I have two modules included with my question.  The first sample module works.   But the second does not work with real code.  This  is the module I need help with.  I have a sample json file included.  Any help would be greatly appreciated.
JSONMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Bill Prew

8/22/2022 - Mon