Communicating with objects in Excel Forms

[bklabel1]

I have a workbook with a form. On the form is an edit box. The user filled in data to the edit box on the form.

In an external VBScript (Not VBA) I have created the Excel Object and Workbook object that contains the form with the edit box. Is there a way to get the values and even perhaps properties of the objects on the form?

Something such as :

theValue = oWB.form1.editbox1.value

Thanks,

Kevin

 

[Norie]

Kevin

Do you mean a userform?

 

[bklabel1]

Norie,
I believe that is called a userform.

It starts out as a gray frame. Then I use the Toolbox to put objects on it. I can double click and put code behind the objects.
Thanks,
Kevin

 

[Norie]

Kevin

So what exactly would the external script be doing?

Would it be accessing a workbook another user has opened and grabbing the data they've entered on the 'form'?

 

[bklabel1]

Norie,

I am working with an automation test tool named UFT.
I have excel workbooks that have test data.
I have a userform in the workbook that asks a few questions such as what starting row of the workbook do you wish to start with and then launches the test tool. The test tool allows scripts to be written in VBScript. I want this VBScript code to go back to the same workbook that launched the script and get the information from the userform that has the script launch button.
Hopefully I explained this clearly.

Thanks,
Kevin

 

[Norie]

Kevin

Still not 100% sure what you want to do but it sounds like you would need programmatic access to the VBE and I'm not sure what would be possible at runtime.

What code do you currently have?

 

[bklabel1]

Norie,
I don't have any code yet.
I need to write something as a starting point and share it to ask questions about it.
Thanks,
Kevin

 

[Norie]

Kevin

You could write code to create an instance of Excel, open the workbook in that instance and then show the userform but where would you want to go from there?

 

[bklabel1]

Norie,
First Norie...I appreciate you having this chat with me.
I would want to get the text that is in a text field on the userform.
Thanks,
Kevin

 

[Norie]

Kevin

That's the bit I'm not quite getting, the text in a textbox on the userform would either be entered manually by a user, through code in the userform module or through the ControlSource property of the textbox.