VBA not working in Excel for MacOS

[erjosito]

The VBA code is not working for Mac OS X. There are some minor issues (like environment variables having different names, but the main problem is that the "Microsoft Scripting Runtime" is apparently not available in Office for Mac. This runtime is required to work with objects like dictionaries, which are required to process the JSON code.

[erjosito]

Somehow relevant to this, I have started playing with the automatic generation of macro-free .xlsx files, have a look in the spreadsheet folder.

I am using the Python module openpyxl, it does not support all Excel features so I needed to simplify the spreadsheet, but the result is IMHO acceptable.