Question

1
Replies
60
Views
SHERYW18 Member since 2017 6 posts
RBC Royal Bank
Posted: 2 years ago
Last activity: 2 years 4 months ago
Closed

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)

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

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn