Data Link Properties Thumbs.
Hi,
In my automation, I have it opening an excel file. When it located the excel file in the directory and opens it, the "Data Link Properties" form comes up and an excel Book1 with sheet called "thumbs." I do not have any connect to any database and would like this to stop as it is failing my automation.
When I open file manually, data link properties does not appear. I also checked "Data Connections" in excel, there is no database there.
Error message:
Automation: RunButton
Exception from HRESULT: 0x800A03EC
Inner Exception: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at OpenSpan.Office.MicrosoftExcel.CreateOfficeInstance()
at OpenSpan.Office.MicrosoftExcel.set_Workbook(ExpandableFilePath value)
at OpenSpan.Office.MicrosoftExcel.Open(String workbook)
Hi,
In my automation, I have it opening an excel file. When it located the excel file in the directory and opens it, the "Data Link Properties" form comes up and an excel Book1 with sheet called "thumbs." I do not have any connect to any database and would like this to stop as it is failing my automation.
When I open file manually, data link properties does not appear. I also checked "Data Connections" in excel, there is no database there.
Error message:
Automation: RunButton
Exception from HRESULT: 0x800A03EC
Inner Exception: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at OpenSpan.Office.MicrosoftExcel.CreateOfficeInstance()
at OpenSpan.Office.MicrosoftExcel.set_Workbook(ExpandableFilePath value)
at OpenSpan.Office.MicrosoftExcel.Open(String workbook)
StackTrace: at OpenSpan.Automation.EventLink.Execute(Object sender, ExecutionEventArgs e)
at OpenSpan.Automation.EventLink.OnReceiveEvent(Object sender, ExecutionEventArgs e)
at OpenSpan.Automation.ConnectableWorker.FireComplete(Object sender, ExecutionEventArgs e)
at OpenSpan.Automation.EntryPoint.InvokeMethod(Object[] paramValues, ComponentIdentity callingMethodId, ExecutionEventArgs callingExecutionArgs)
at OpenSpan.Automation.ConnectableMethod.ExecuteInvoke(Object instance, Object[] parameters, ExecutionEventArgs e)
at OpenSpan.Automation.ConnectableMethod.DoCustomWork(Object instance, Hashtable inputValueHash, Hashtable outputValueHash, ExecutionEventArgs e)
at OpenSpan.Automation.ConnectableWorker.DoWork(Object sender, ExecutionEventArgs executionArgs)
Thanks