Error with SendKeys method of Excel Connector

Asked By 0 points N/A Posted on -
qa-featured

Hello Experts,

 

In using the SendKeys method of Excel Connector,  I got the following error  as I was to use the method on an  automation. The log information is given below.
1) Exception Information
*********************************************
Exception Type: OpenSpan.Exceptions.BaseApplicationException
MachineName: GNWK-INA121P3FF
CreatedDateTime: 11/3/2011 11:24:56 AM
AppDomainName: DefaultDomain
ThreadIdentityName: TIGERmbansal
WindowsIdentityName: TIGERmbansal
Message: Property: microsoftExcel1.ExcelApplication on Instance: Automator-8CE6798F6B756A9MicrosoftExcel-8CE6798FA2BD94B is null.
Data: System.Collections.ListDictionaryInternal
TargetSite: System.Object GetSubPropertyInstance(OpenSpan.Automation.ConnectableHost, System.Object)
HelpLink: NULL
Source: OpenSpan.Automation

StackTrace Information
*********************************************
at OpenSpan.Automation.ConnectableHost.GetSubPropertyInstance(ConnectableHost connectableHost, Object instance)
at OpenSpan.Automation.ConnectableHost.GetInstance(ExecutionEventArgs executionArgs)
at OpenSpan.Automation.Design.ConnectionBlocks.CustomConnectionBlock.get_InstanceUniqueId()
at OpenSpan.Automation.Design.ConnectionBlocks.CustomConnectionBlock.get_ShowDesignCompName()
at OpenSpan.Automation.Design.ConnectionBlocks.ConnectionBlock.GetBestWidth()
at OpenSpan.Automation.Design.ConnectionBlocks.BaseBlock.Layout()
at OpenSpan.Automation.Design.ConnectionBlocks.ConnectionBlock.Initialize(IConnectableHost connectableHost, IServiceProvider serviceProvider, Boolean initialCreate)
at OpenSpan.Automation.Design.ConnectionBlocks.MethodBlock.Initialize(IConnectableHost connectableHost, IServiceProvider serviceProvider, Boolean initialCreate)
at OpenSpan.Automation.Design.AutomationView.AddComponentToDocument(Object instance, ComponentIdentity instanceUniqueId, Type instanceType, MemberInfo[] memberInfos, String subProperty, Point position, Boolean fromObjectInspector, Boolean wrapInTransaction)
at OpenSpan.Automation.Design.AutomationView.DropOnView(DragEventArgs e, PointF docPoint)
at OpenSpan.Automation.Design.AutomationView.DoExternalDrop(DragEventArgs e)
Verbose | 11:25:50.713 AM | 7 | OSS | | | BasePublisherService – time out, sending batch
Error | 11:26:48.946 AM | 1 | Exception | | | Property: microsoftExcel1.ExcelApplication on Instance: Automator-8CE6798F6B756A9MicrosoftExcel-8CE6798FA2BD94B is null., Verbose Message: General Information

Diagnostic Info:
Diagnostic.MachineName: GNWK-INA121P3FF
Diagnostic.FullName: OpenSpan, Version=5.1.0.0, Culture=neutral, PublicKeyToken=null
Diagnostic.AppDomainName: DefaultDomain
Diagnostic.WindowsIdentity: TIGERmbansal
Diagnostic.ApplicationName: OpenSpan.Studio.Shell 

Here goes the screenshot of the error.

Encountered problem adding object to automation:

Property: microsoftExcel1.ExcelApplication on Instance : Automator-8CE6798F6B756A9MicrosoftExcel-8CE6798F6B75D94B is null.

See diagnostic log for full exception information.

OK

Please help.

SHARE
Answered By 0 points N/A #197522

Error with SendKeys method of Excel Connector

qa-featured

Hello,

This error occurs if some controls such as OCXs and DLLs are used. Start by verifying to where the DLL references are pointing. Then, go to VBA IDE and select Tools then references and check the libraries dates for accuracy. In addition, unregister mscomctl.ocx and register it back may solve the problems. Try these steps:
Step 1. open the console and run cmd.exe as an administrator and type regsvr32 /u mscomctl.ocx
Step 2. Now register mscomctl.ocx.
Type regsvr32 c:windowssystem32mscomctl.ocx for 32-bit Windows systems. Type regsvr32 c:windowssyswow64mscomctl.ocx for 64-bit Windows systems.
 
I hope this is useful.

Login/Register to Answer

Related Questions