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

DTS cannot access controls within a sheet.
Yo have to store your data in cells.

DTS sees rows (with several fields as columns)

HTH
--
AP

"Ant(antonfh_at_gmail_dot_com)"
a écrit dans le message
de news: ...
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

Yes thanks.

No see that is why I created one sheet where I keep all my values in one
row, the other worksheets are so formated to make it easy for someone to fill
in the values, but my "data" sheet simply referes to the cells (where ever
they may be - some are on different worksheets) I want to use my "data" sheet
to allow DTS to get all the values without problem.... my problem is I dont
know how to put on my "data" sheet those values that are in ComboBox fields?

Anton

"Ardus Petus" wrote:

DTS cannot access controls within a sheet.
Yo have to store your data in cells.

DTS sees rows (with several fields as columns)

HTH
--
AP

"Ant(antonfh_at_gmail_dot_com)"
a écrit dans le message
de news: ...
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

Please upload your workbook on http://cjoint.com and post back the link.
I will be glad to help.

--
AP

"Ant(antonfh_at_gmail_dot_com)"
a écrit dans le message
de news: ...
Yes thanks.

No see that is why I created one sheet where I keep all my values in one
row, the other worksheets are so formated to make it easy for someone to
fill
in the values, but my "data" sheet simply referes to the cells (where ever
they may be - some are on different worksheets) I want to use my "data"
sheet
to allow DTS to get all the values without problem.... my problem is I
dont
know how to put on my "data" sheet those values that are in ComboBox
fields?

Anton

"Ardus Petus" wrote:

DTS cannot access controls within a sheet.
Yo have to store your data in cells.

DTS sees rows (with several fields as columns)

HTH
--
AP

"Ant(antonfh_at_gmail_dot_com)"
a écrit dans le
message
de news: ...
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