Hello all,

I am trying to automate excel application using rational robot. Because the rational robot not recognized the objects, I tried coding vba so that I can use that code in robot.

I have a window with username that I need to select and submit which does some process.

I am able to call the menu item using the below code but once the window is displayed I cannot click the submit button.


In vba.. after this code i.e once the window is displayed I cannot go for next line of code in debugging mode as well.

Application.CommandBars("Worksheet Menu Bar").Controls("Data").Controls("Create Template").Execute

Please help me out.




This is the rational script code:

Dim objExcelApp as object

Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Visible = true

objExcelApp.Workbooks.Open ("F:\data development\Test Data Creation Tool\Test Data Creation Tool.xla")
objExcelApp.Application.CommandBars("Worksheet Menu Bar").Controls("Data").Controls("Create Template").Execute

Window SetContext, "Caption=Create Template", ""
objExcelApp.Controls("Uname").Value="ADMIN"


Thanks,
sanjay

Can you try SendKeys

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)