Forum Discussion
Greg_Lowe425
Sep 15, 2022Copper Contributor
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