I need advice to develop an application using excel to develop a "shopping
Cart" procedure.

I have a excel database with product codes and specifications as a table :
headings are in columns and data is in rows. I have many (12) worksheets
where customers can choose (single option botton..True for selected False for
non selected) from diferents segments and products. In each worksheet
customers select or no the right product for them.

The problem:

The database is used to extract references like product name and other
specifications (using funtions like index and vlookup) so if i change the
secuence (order) the specfications will change or get a data error.


The issues here a

1) How to develop the procedure to extract only selected items from database
when the customers click on an "add to cart" button or something like this?

2) How to develop a procedure to put the selected items (extrated above)
into a pre formated customer invoice?

Considerations:

I will also appreciatte If somebody tell me where i can found an example
for this.

Thank for your support.

regards,


alex
madrid-spain


This application will run for only one customer per session.

Not sure exacly what you are asking for, but what I have done on similar
projects working with Access is to create a query string, such as if your key
is item number, then when you hit the run button for each that is checked
append to a string something like..
if QueryString ="" then querystring = cells(x,y)
if QueryString <"" then querystring = querystring & ", " & cells(x,y)

not the above exactly but basically you are building your db datastring with
all of the selected items. Hope that made sense.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"alex" wrote:

I need advice to develop an application using excel to develop a "shopping
Cart" procedure.

I have a excel database with product codes and specifications as a table :
headings are in columns and data is in rows. I have many (12) worksheets
where customers can choose (single option botton..True for selected False for
non selected) from diferents segments and products. In each worksheet
customers select or no the right product for them.

The problem:

The database is used to extract references like product name and other
specifications (using funtions like index and vlookup) so if i change the
secuence (order) the specfications will change or get a data error.


The issues here a

1) How to develop the procedure to extract only selected items from database
when the customers click on an "add to cart" button or something like this?

2) How to develop a procedure to put the selected items (extrated above)
into a pre formated customer invoice?

Considerations:

I will also appreciatte If somebody tell me where i can found an example
for this.

Thank for your support.

regards,


alex
madrid-spain


This application will run for only one customer per session.

Thank John. The datastrings has some good points but are limited to 255
characters. I will try it if there are no better solution.

"John Bundy" wrote:

Not sure exacly what you are asking for, but what I have done on similar
projects working with Access is to create a query string, such as if your key
is item number, then when you hit the run button for each that is checked
append to a string something like..
if QueryString ="" then querystring = cells(x,y)
if QueryString <"" then querystring = querystring & ", " & cells(x,y)

not the above exactly but basically you are building your db datastring with
all of the selected items. Hope that made sense.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"alex" wrote:

I need advice to develop an application using excel to develop a "shopping
Cart" procedure.

I have a excel database with product codes and specifications as a table :
headings are in columns and data is in rows. I have many (12) worksheets
where customers can choose (single option botton..True for selected False for
non selected) from diferents segments and products. In each worksheet
customers select or no the right product for them.

The problem:

The database is used to extract references like product name and other
specifications (using funtions like index and vlookup) so if i change the
secuence (order) the specfications will change or get a data error.


The issues here a

1) How to develop the procedure to extract only selected items from database
when the customers click on an "add to cart" button or something like this?

2) How to develop a procedure to put the selected items (extrated above)
into a pre formated customer invoice?

Considerations:

I will also appreciatte If somebody tell me where i can found an example
for this.

Thank for your support.

regards,


alex
madrid-spain


This application will run for only one customer per session.