I still think it's doable, Allan. If you want to bounce around ideas, I'm open.

>Gerry,
>
>There are many more items.
>Actually, this was only an example.
>Each of these 'grids' is probably about 2 * 2 to about 10 * 6 plus columnar headings and another couple of lines to describe the product group as shown.
>Some of the cells will have to be protected because a particular colour/size may be not for sale.
>There will be probably be about 20 of these 'grids'.
>
>>This looks like such a "small" grid (5x4), I would simply use a VFP form with textboxes and use array reference to the textboxes.
>>
>>I would look at the different products in question and see if the creation of the input forms could be (meta) data driven.
>>
>>>I was brainstorming today with one of our clients who is using one of our order entry applications.
>>>The appearance of the current application is probably somewhat typical in that the products are in the grid and each line has the item #, description, price, quantity (entered by user) and extension of the line.
>>>He mentioned that several of the endusers would rather see the input screen in a spreadsheet format such as:
>>>
>>>Gloves - Leather
>>>Mens
>>>Colour S M L XL Total
>>>Black
>>>Brown
>>>Grey
>>>Total
>>>
>>>The endusers would enter the qty's per colour/size and Excel would calculate the totals both for the colour and the size.
>>>Also, each colour/size would be a different item #.
>>>
>>>From a tecnical viewpoint, I would prefer not to use a hardcoded Excel template but build the speadsheet in VFP 7 and invoke Excel. When they are finished, I would want to bring the data back into VFP 7.
>>>
>>>Has anyone done something similar and hopefully point me in the right direction?
>>>TIA.