read object/control value in excel

Dec 16, 2009 at 7:47 AM

Dear owner,

i really exciting with your object, i have tried and successfully,  but i have a question for you, hopefully you can give any solution regarding your object.

the question is how can i read the object/control value that in excel worksheet, for example: i have a registration form using excel and in that excel i have 4 dropdownlist, how can i read and get the value of 4 dropdownlist.



Jan 5, 2011 at 9:50 AM

I have the same issue. I have an excel with 50 sheets and on the first sheet there is a list of clients.

On the rest of the sheets, the first list of clients is loaded in a drop-down and then for the clients their name is filled in afterwards with a formula.


The dataset method reads everything up until the drop-down is found.

Any help?