Use VBA To Run a Powershell Command and Get Return Value

[@GerryStilton]

Thank you for sharing.

[@lemr1972]

I got this message error: run-time erorr '429' ActiveX component can't create object.

[@user-xq1ed1pg6r]

When you type wShell, the intellisense shouldn't complete the sentence and bring the object methods?

[@younghwangbo6198]

How can I get the shell return values to cells in row

[@neoeason92]

Can powershell in VBA be run in 64bit excel? Or it's only available in 32bit?

[@paulsherwood9572]

Crashes Excel! I have carefully copied exactly what you did - Excel simply closes. I have also tried it with the -executionpolicybypass but it doesn't make any difference. Thank you for any tips

[@Henry-km4fe]

I get variable not found on set wShell