Thread: Using PowerShell instead of VBA, to automate Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adrian Caspersz Adrian Caspersz is offline
external usenet poster
  
Posts: 19
Default 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
Reply With QuoteReply With Quote