I need assistance with automating an Excel process that involves running a macro which utilizes functions from the Cap IQ plugin. Here’s the scenario:

Objective:
Generate an email from an Excel spreadsheet containing dynamic data every day at 12 PM. The macro performs calculations using functions from the Cap IQ plugin.

Current Setup:

I have written a PowerShell script that opens, activates, and runs the macro in the Excel spreadsheet.
The Cap IQ plugin is installed and functions correctly when the macro is run manually in Excel.
The PowerShell script verifies that the plugin is installed and connected

Issue:
When I run the macro manually from Excel, it executes correctly without any issues. However, when I run the macro via the PowerShell script, Excel does not recognize the functions from the Cap IQ plugin and displays #NAME errors.

I am seeking guidance on how to ensure the Cap IQ plugin functions are recognized when run via PowerShell.

$excelFilePath = "path"
$excel = New-Object -ComObject Excel.Application
$excel.Visible = $true
$workbook = $excel.Workbooks.Open($excelFilePath)

when I see the excel spreadsheet.
I see #NAME.
When I open regularly it works.

Are there any additional steps or configurations needed to properly load and utilize the Cap IQ plugin in this automated scenario?

Any insights or solutions would be greatly appreciated.

#NAME errors where Excel doesnt recognize the plugin