Ok as I said earlier you need to write this with VBA, not sure if that is the name used for .Net stuff in Excel these days.
But I am going to make the assumption that people who get your spreadsheet, will have some form of login to your website. So what you do is write the code to do what you need to do on your sheet, but make sure it is protected, and only allow the areas that you need them to edit to be unprotected. Then you can have a button somewhere that says upload data to (insert your company here or something that they can refer to as your site). This will then run a VBA function that will then ask them to enter the details needed to authenticate them, which will have error trapping in case they try without a connection the net, or there is some other error connection to your server. Once there you can then take the data convert it to what ever format you need, and simple post the data to a secure function on your server. It is that simple... On Fri, Sep 30, 2011 at 10:58 PM, Mo Lay <[email protected]> wrote: > > >Sure, what would you like to know. > > > > > > > > > >> > Hi Andrew, > > BEcause i need to refere the data to a specific ID i need the user to be > able to send his data from excel to Oracle and usnig that ID provided from > the web form as reference ? > > can you explain to me steps to take to send the excel data from the > spreadsheet to oracle.. > will i need to use ODBC connection ? if so , my users are using same > template but different copies. > > > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5643 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
