Now I could throw another curve ball at you here. And I am not sure this is possible, but I can't see why not.
When the user is entering the data, you could potentially lock the sheet down so that only certain rows can be entered any data into. You could then provide a button to upload the data to your site through VBA in the spreadsheet, this could then potentially double check the data is valid to your specifications before uploading to your site, and notify the user if something is missing or wrong at this point as well. Now this scenario is based on a lot of unknowns about your setup, as it assumes that you know VBA, and that there is a secured connection that the websheet can connect too. But with some more thought I don't see why this couldn't be another approach to the problem either. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Wed, Sep 14, 2011 at 2:27 AM, Mo Lay <[email protected]> wrote: > > > Thanks guys , > I really appreciate your guidance and the way you are explaining and > justifying the right use of tools. > > The purpose of this is the following : > my users have to use a specific excel template that i provide them . This > excel template includes many calculations and has a sheet called "Data > Sheet" where sone data are found not all the sheet is used but only a > section of 36 rows X 4 columns > what i need is to have the user : > 1- the user browse for this file and click a button "submit data" > 2- onclick , excel data "Data Sheet" will be captured/returned to query a > 3- insert the query data into a database. > > that is exactly what i am looking at...not sure if this is clear for you > guys ? > > thanks for the help !! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5596 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
