Groups > microsoft.public.excel.programming > #111278

Using PowerShell instead of VBA, to automate Excel

From	Adrian Caspersz <email@here.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Using PowerShell instead of VBA, to automate Excel
Date	2019-12-23 23:28 +0000
Organization	Keep Usenet Text Newsgroups Alive!!
Message-ID	<h6d0tlFbii1U1@mid.individual.net> (permalink)

Show all headers | View raw

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/powershell-read-excel-file-using-com.html

-- 
Adrian C

Back to microsoft.public.excel.programming | Previous | Next | Find similar | Unroll thread

Thread

Using PowerShell instead of VBA, to automate Excel Adrian Caspersz <email@here.invalid> - 2019-12-23 23:28 +0000

csiph-web