VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX ...
A boring setting with huge payoff.
One thing to note here is you can also use double triple quotes for multiline strings(""" """ like this). Do you remember I said(ok wrote) there is something called unassigned strings in this post?