I have a whole slew of excel files that contain data that I want t
compile into a single excel sheet. I've been able to automaticall
grab the values in each file, but am having a terrible time trying t
figure out how to grab the values of form controls. To be precise
few option buttons groups and drop down controls. I know you could d
a cell link then just get the value from there, but unfortunately th
designer didn't do that and I have over a hundred files. I'm prett
much lost. Is there any way to reference the value something like...

excelfile.worksheet.dropdown1.value

I've looked forever trying to find something, but I can't fin
anything. If anyone can point me in the right direction it would b
much appreciated.
Thank

--
entonn
-----------------------------------------------------------------------
entonne's Profile: http://www.excelforum.com/member.php...fo&userid=1503
View this thread: http://www.excelforum.com/showthread.php?threadid=26656