If not, this tutorial will be pleasantly surprising for you. In this article, we are going to show you how you can convert a CSV file to an Excel workbook. For that, we will be using a VBScript.

I don't know anything about "Declare Function"; these are just added via Tools | References in the Excel VBA editor, and then they're added to the libraries listed in the Object Browser, and ...

Within Power Automate, it has been possible to run scripts in Excel using the Run Script actions. Did you know that the is a Run Scripts from SharePoint library action too?