Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a ...

Such buttons often run macros that you write using Visual Basic. When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window.

I need to be able to run a vbscript at night to export the contents of an Access DB to an Excel spreadsheet. Any suggestions how to do this?