I am trying to open an excel workbook, connect to the Refinitiv Addin and refresh some formulas using python win32com.client, but unfortunately that is yielding an error as highlighted below.
Here's the code I am using:
import win32com.client
excel = win32com.client.Dispatch("Excel.Application")
wb = excel.Workbooks.Add()
excel.COMAddIns("PowerlinkCOMAddIn.COMAddIn").Connect = True
The last line results in the following error:
com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2147467260), None)
How do I resolved this error?
