The attached zip contains
- an Excel file with a Power Query connection to the Sunrise-Sunset url Jim Taylor noted in that thread
- a text file of the Mcode for the query with a replacement section
- a .wbt script that loads the file and has 2 udfs
The udf chkit() - merely runs code to output the query name, connection name, connection string
The udf changeit() - should update the Month of the query from May to August (but you can change the month you want to see.
I'm intrigued that Mcode { not sure, but think the name comes from the 'mashup' OLEDB Provider Power Query uses ] can be used as a simple text file.
I would appeciate it if someone would download and try the script just to confirm that it doesn't just work for me. My next step would be to create an Mcode template and create Power Query from a blank workbook.