View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ant(antonfh_at_gmail_dot_com)
 
Posts: n/a
Default Values of ComboBox fields and SQL

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