Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Major headache: For one I want to take a Excel file and maybe using DTS in
SQL write the values in the database. On the spreadsheet I have created a "form" some of which is active-x control ComboBox, I have one sheet just to get all my values (BUT I dont know how to get the value of a ComboBox ??) for example to get one of the cells used as a form, I would have ='Daily Log'!D4 - using this system I have one worksheet where I get all the values in each column (or row, what ever is better later in creating some DTS script) BUT I cant get the value of the form where I have a ComboBox (not sure how to do this?) I tried Form.ComboBox1 etc... The other side is then to save it in one location and getting some DTS script to get these values and save them into the database. Anton |