Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Using PowerShell instead of VBA, to automate Excel

Started byAdrian Caspersz <email@here.invalid>
First post2019-12-23 23:28 +0000
Last post2019-12-23 23:28 +0000
Articles 1 — 1 participant

Back to article view | Back to microsoft.public.excel.programming

Contents

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

#111278 — Using PowerShell instead of VBA, to automate Excel

FromAdrian Caspersz <email@here.invalid>
Date2019-12-23 23:28 +0000
SubjectUsing PowerShell instead of VBA, to automate Excel
Message-ID<h6d0tlFbii1U1@mid.individual.net>
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

[toc] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web