Monthly Archives: Sep 2020

Nested JSON to flat data tables

Posted on Sep 28, 2020 by Patrick O'Beirne, Excel/VBA developer

Have you ever had to convert a file of JSON text to Excel tables? Not simple JSON, but one with a collection of dictionaries inside a dictionary inside a collection of dictionary records inside another collection of records inside a … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

VBA Read Unicode file contents in various encodings

Posted on Sep 28, 2020 by Patrick O'Beirne, Excel/VBA developer

To read a text file, you need to be able to handle more character sets than just ANSI. Not just in the contents but also in the file and folder names.The classic article on this is by Joel Spolsky:https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/ Here … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments