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

 

[bklabel1]

Norie,

The user would fill in the EditBox on the UserForm.

Code in VBScript which would reside outside of Excel looks like this:

Dim oExcel
Dim oWb
Dim oSheet

Set oExcel =  CreateObject("Excel.Application") 
Set oWb = oExcel.WorkBooks.Open("C:\KAA\KAA.XLSM") 

msgbox oWb.UserForm1.height

oWb.Close
Set oExcel = Nothing
Set oWb = Nothing

 

[bklabel1]

But the code above does not work. The msgbox line of code gives an error.

 

[Norie]

A userform isn't a part of the Excel application object model.

By the way, I'm still not sure where the 'user' would be involved in the testing.

 

[bklabel1]

Norie,
Yup its not in the object model.
I have a button kicking off a test tool. The test tool uses VBscript. I want to tell the test tool to test using particular features.
The thing that I'm sending data to does not have to be a testing tool. I'm trying to find out how to get to information on the UserForm.
I'm getting convinced that it is not possible. I could send the data from the Object on the UserForm to a temporary tab/sheet. The outside tool could read from the temp sheet. I'm not too happy with that idea. I wish there was another place that an outside program could read from.
Thanks,
Kevin