OLEObjects ComboBox (ActxServer Matlab Excel)

9 visualizaciones (últimos 30 días)
Arezki
Arezki el 2 de Jul. de 2014
Respondida: Arezki el 2 de Jul. de 2014
Hellow
How can i change the current selected item of an ComboBox in Excel by Matlab For example i have a CamboBox in Excel with 3 elements (a,b,c), the current selected element is "b" so i would like select the first Element "a" i tried this:
Excel=actxserver('Excel.application');
Excel.Application.DisplayAlerts=0;
File=Excel.Workbooks.Open('MyExcelFile');
Param=File.Sheets.Item('Param');
Param.OLEObjects.Item('ComboBox1').Object.List % to get the list of element
Param.OLEObjects.Item('ComboBox1').Object.Value % to get the current selected item
................................................ % how to select ather element of list?
Param.OLEObjects.Item('ComboBox1').Object.Value= 'b' % does'nt work
Thenk yo

Respuesta aceptada

Arezki
Arezki el 2 de Jul. de 2014
Param.OLEObjects.Item('ComboBox1').Object.Value= 'b'
It's work, i had just problem with Excel :)

Más respuestas (0)

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by