Migrating powershell scripts that use com object excel.application

Occasional Visitor

I have PowerShell scripts that automate process and loads the result into Excel.  I use the following statement on box where Office16 installed.  After running the below command the $excel variable is filled with information about the object.  When I use the statement on a machine where Office 365 Enterprise is loaded the value of $excel has the structure but no values.

$excel = New-Object -ComObject Excel.Application

 

I need to understand why this is happening and how to resolve the issue.

0 Replies