Getting and Setting the values of Excel Dropdown controls

mkroeger · Post by **mkroeger** » Tue Mar 25, 2014 9:34 pm

My goal is to write a script that copies the values of cells and objects in one existing excel sheet, and transfers/pastes them to another existing excel sheet. Not a complete copy/paste, but selectively.
I have successfully written the script using XLOPEN, XLGetCell and XLSetCell. These work great for the cells but not for the content that is in controls.
Each sheet has a set of 10 drop down controls that have a value of a product id. I need to copy these values of the controls from one sheet to the other.

Can this be done with a VBScript routine, at the same time that I have these two files open with the XLOpen command?

something like: ActiveSheet.Shapes.Range(Array("ComboBox")).Value

Thanks,
Mike

mkroeger · Post by **mkroeger** » Tue Mar 25, 2014 10:28 pm

Duh!

Guess I could just do all the copying in vbscript! that would solve the control problem of which method has the files open at what time!!!