VB controls in excel are not getting captured in OR

Ask general questions here.
Nithya87
Posts: 3
Joined: Wed Jan 04, 2012 9:06 am

VB controls in excel are not getting captured in OR

Post by Nithya87 » Wed Jan 04, 2012 9:54 am

Hi,

We have been doing a POC for one of our applications using Ranorex.

We need to use some VB controls which is embedded in excel. While recording, these controls are not getting captured in object repository.

Please suggest any work around for this.

Nithya

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

Re: VB controls in excel are not getting captured in OR

Post by Support Team » Wed Jan 04, 2012 11:14 am

Hi,

Can you post a snapshot of your excel sheet with the VB controls.

Regards,
Martin
Ranorex Support Team

Nithya87
Posts: 3
Joined: Wed Jan 04, 2012 9:06 am

Re: VB controls in excel are not getting captured in OR

Post by Nithya87 » Thu Jan 05, 2012 6:36 am

Hi,
I have marked the controls in the attached file.


Nithya
You do not have the required permissions to view the files attached to this post.

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

Re: VB controls in excel are not getting captured in OR

Post by Support Team » Thu Jan 05, 2012 9:26 am

Hi,

Please provide a Ranorex snapshot (not a screenshot) of the state of the application.

Creating a Ranorex Snapshot: http://www.ranorex.com/support/user-gui ... files.html

Regards,
Martin
Ranorex Support Team

Nithya87
Posts: 3
Joined: Wed Jan 04, 2012 9:06 am

Re: VB controls in excel are not getting captured in OR

Post by Nithya87 » Fri Jan 06, 2012 4:37 am

Hi,

Attaching the snap shot for the whole sheet(Which includes Request table) . Please let me know if you require screenshot of any specific VB controls.

Nithya
You do not have the required permissions to view the files attached to this post.

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

Re: VB controls in excel are not getting captured in OR

Post by Support Team » Mon Jan 09, 2012 4:45 pm

Hi,

We was able to reproduce it and it seems if you have an froze pane in your worksheet Ranorex is not able to detect the correct visible state of the controls. Meanwhile please add you controls to your repository using the spy and manually create your recordings.
We will try to fix that issue and we will release it with one of the next versions of Ranorex.

Regards,
Peter
Ranorex Team