Through the API you have the ability to download with a higher limit or unlimited. You could create a VBA script that hits the relevant Looker API endpoint to get the results. This code sample on Stackoverflow seems to outline the basic structure of such a script.
You’ll need to add authentication for the API (the login workflow and subsequently pass the returned token in the headers) and update the endpoint itself. I’m not an avid user of VBA so I can’t provide any actual code snippets, but I’ve done something similar for Google Sheets that follows the same structure in Apps Script (JS).