To show the userform, you have to run code contained in the workbook that
contains the userform.

You can have that code return a reference to the userform to your code and
then use that to address the userform.

--
Regards,
Tom Ogilvy




"Thomas" wrote:

> Hi,
>
> I am opening an excel spreadsheet with a userform from another application
> (see code below) using late binding. I need to populate controls with data.
> How do I reference the userform?
>
> Set objExcel = CreateObject("Excel.Application")
> Set wbExcel = objExcel.Workbooks.Open("C:\test.xls")
>
> I tried wbExcel.UserForm11.TextBox1.Text and it does not work. Any ideas?
>
> Thanks
>
>
>