I want to put some Raw Data into a new Excel File with PowerShell. I’m aware how to use the comobject Excel.Application which PowerShell delivers.
Now my problem is the Data has to be processed in different ways inside the Excel (during the running of the script). I already created some VBA Macros to do so a while back and now I’d like to reuse them. Is it possible to “use” the VBA through the Script inside the newly created and filled up Excel? Or do I need to recreate the VBA in Powershell?