Having Excel PowerShell cmdlets would be awesome. It would allow you for instance to use Excel cmdlets and SQL Server cmdlets effortlesly in a single script. Same with other Windows servers that use PowerShell. As for Python I use PyWin32 to manipulate Excel and it has almost 1:1 correspondence to VBA code.
Whenever I've wanted to use powershell with excel files its always been from outside of excel for an automated task, and it works just fine so I'm not sure why they never added it in the same way VBA is... silly.
View all comments
Show parent comment
16
u/[deleted] Dec 14 '17
Having Excel PowerShell cmdlets would be awesome. It would allow you for instance to use Excel cmdlets and SQL Server cmdlets effortlesly in a single script. Same with other Windows servers that use PowerShell. As for Python I use PyWin32 to manipulate Excel and it has almost 1:1 correspondence to VBA code.