Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel automation fails from PowerShell when PIa are installed. | Excel Programming | |||
Excel and PowerShell | Excel Discussion (Misc queries) | |||
Can you automate numbers in Excel? | Excel Discussion (Misc queries) | |||
Automate Excel from VS.NET | Excel Programming |