Posted to microsoft.public.excel.programming

Thomas[_21_] Thomas[_21_] is offline

external usenet poster

Posts: 2

UserForm Issue

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
userform date issue	Woodi2	Excel Worksheet Functions	4	February 7th 09 02:18 PM
UserForm Save Issue	DarnTootn	Excel Worksheet Functions	0	May 11th 06 05:15 PM
Multiple Users in Userform issue	bigbri	Excel Programming	4	April 6th 06 07:06 PM
Userform Issue	Bill[_30_]	Excel Programming	3	January 21st 06 02:27 PM
UserForm Listbox issue	bach	Excel Discussion (Misc queries)	29	October 6th 05 01:48 PM

All times are GMT +1. The time now is 06:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us