By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Get the value from a single cell

P: n/a
hello,

i am trying to create an aplication in which I have to get some single
values in different excel cells to place them together and update a table.

in other words, something like this:

value1= worksheet1.cellA23
value2=worksheet2.cellB52

update table tblTemp values value1, value2...

can i do this?

Thanx
Rui Patinha
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yes you can. You can either create a SQL statement to do this in code or
create a Jet Query that takes parameters and do it that way. If you need
more help on the implementation you'll need to give a little more detail
(e.g. is the code in Excel or Access, What have you tried so far, etc)

"Rui Patinha" <rui_ponto_patinha_em_universus_pt> wrote in message
news:3f**********************@news.telepac.pt...
hello,

i am trying to create an aplication in which I have to get some single
values in different excel cells to place them together and update a table.

in other words, something like this:

value1= worksheet1.cellA23
value2=worksheet2.cellB52

update table tblTemp values value1, value2...

can i do this?

Thanx
Rui Patinha

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.