Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Forms controls from outside
Hi,
I will telecommand an excel application from another excel application. All works fine, except 2 combobox form controls, which I can't set from outside. How can I set a combobox form control in an App1 by code from my 2nd App? Set app1 = CreateObject("Excel.Application") Set wb1 = appSchein.Workbooks.Open("Test.xls") Set ws1 = wbSchein.Worksheets("Employees") app1.Visible = True ws1.Activate ws1.Shapes("combobox1").select ?????????????????? does not work SendKeys ("February") ?????????????????? Thanks Hans |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Forms controls from outside
You mean a the forms toolbar and not the control toolbox toolbar
Dim drpdown as Excel.DropDown .. . . set drpdown = ws1.Dropdowns("combobox1") drpdown.ListIndex = 2 -- Regards, Tom Ogilvy "Hans Preuer" wrote in message ... Hi, I will telecommand an excel application from another excel application. All works fine, except 2 combobox form controls, which I can't set from outside. How can I set a combobox form control in an App1 by code from my 2nd App? Set app1 = CreateObject("Excel.Application") Set wb1 = appSchein.Workbooks.Open("Test.xls") Set ws1 = wbSchein.Worksheets("Employees") app1.Visible = True ws1.Activate ws1.Shapes("combobox1").select ?????????????????? does not work SendKeys ("February") ?????????????????? Thanks Hans |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Forms controls from outside
Hi Tom,
Thank you for your Answer. The combobox is from the control toolbox toolbar and not from the forms toolbar. Your code always results in an error ("Application or object specific error"). Is it possible to do it with a toolbar from the controlbox? Thanks for your help!!! Hans "Tom Ogilvy" schrieb im Newsbeitrag ... You mean a the forms toolbar and not the control toolbox toolbar Dim drpdown as Excel.DropDown . . . set drpdown = ws1.Dropdowns("combobox1") drpdown.ListIndex = 2 -- Regards, Tom Ogilvy "Hans Preuer" wrote in message ... Hi, I will telecommand an excel application from another excel application. All works fine, except 2 combobox form controls, which I can't set from outside. How can I set a combobox form control in an App1 by code from my 2nd App? Set app1 = CreateObject("Excel.Application") Set wb1 = appSchein.Workbooks.Open("Test.xls") Set ws1 = wbSchein.Worksheets("Employees") app1.Visible = True ws1.Activate ws1.Shapes("combobox1").select ?????????????????? does not work SendKeys ("February") ?????????????????? Thanks Hans |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Forms controls from outside
ws1.Activate ws1.OleObjects("combobox1").Object.Value = "February" -- Regards, Tom Ogilvy "Hans Preuer" wrote in message ... Hi Tom, Thank you for your Answer. The combobox is from the control toolbox toolbar and not from the forms toolbar. Your code always results in an error ("Application or object specific error"). Is it possible to do it with a toolbar from the controlbox? Thanks for your help!!! Hans "Tom Ogilvy" schrieb im Newsbeitrag ... You mean a the forms toolbar and not the control toolbox toolbar Dim drpdown as Excel.DropDown . . . set drpdown = ws1.Dropdowns("combobox1") drpdown.ListIndex = 2 -- Regards, Tom Ogilvy "Hans Preuer" wrote in message ... Hi, I will telecommand an excel application from another excel application. All works fine, except 2 combobox form controls, which I can't set from outside. How can I set a combobox form control in an App1 by code from my 2nd App? Set app1 = CreateObject("Excel.Application") Set wb1 = appSchein.Workbooks.Open("Test.xls") Set ws1 = wbSchein.Worksheets("Employees") app1.Visible = True ws1.Activate ws1.Shapes("combobox1").select ?????????????????? does not work SendKeys ("February") ?????????????????? Thanks Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX to Forms controls | Excel Discussion (Misc queries) | |||
Excel forms controls | Excel Discussion (Misc queries) | |||
Forms controls | Excel Worksheet Functions | |||
Forms Controls | Excel Programming | |||
Forms Controls | Excel Programming |