Forum Discussion

Greg_Lowe425's avatar
Greg_Lowe425
Copper Contributor
Sep 15, 2022

Migrating powershell scripts that use com object excel.application

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.

No RepliesBe the first to reply

Resources