ExcelBanter - Using PowerShell instead of VBA, to automate Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using PowerShell instead of VBA, to automate Excel (https://www.excelbanter.com/excel-programming/454524-using-powershell-instead-vba-automate-excel.html)

Adrian Caspersz

Using PowerShell instead of VBA, to automate Excel

Just interested if anyone else is active in doing this.

I've switched to writing COM scripts in PowerShell, to create Excel
spreadsheets on the fly, populate them with data, and initialise pivot
tables. Not having to play with the VBA editor for me is a plus.

https://lazywinadmin.com/2014/03/pow...using-com.html

--
Adrian C

All times are GMT +1. The time now is 03:18 AM.