>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
Hi , This cannot be done at the user level. The user has a form to submit ( project information .). One of the sections/steps of this form is to provide the data calculated on his excel template. Also when data is entered and submitted, there will be a generated key (project ID)in a database associated with the form ID , which will be refering to the project data and be able to report on that later. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5597 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
