We've done this with Access, but it will work exactly the same with Excel. Create an Excel template that has a defined area for the data. Use Jet or Automation to populate a new file created from the template. Then send this to the user.
Inside the template include VBA code to wrap up all the data into XML and send it back to the server when they click a button. You'll need CF5 in order to use XML since you need the GetHttpRequestData() function to get the XML stream. If you're stuck with CF4.5, then you can send the data as form fields instead. Note that this won't work with CFMX right now since there is a bug in GetHttpRequestData() which will be fixed in UR3. HTH, Sam > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 28, 2002 4:01 PM > To: CF-Talk > Subject: excel as a vehicle to collect and write back data to a CF-App > > > I have a customer, > who runs an application, > where he can show, who > is a a promotor or a consultant > for certain products he is selling. > The application runs on: CF 4.5, Win NT 4 Server > with IIS 4 and MS-Access as a backend. > Updating and deleting data works on > a user-data-record base via web-frontend. Now the > customer wants to deliver certain data, that > has to be edited by certain responsible users. > He wants to deliver the lists, the people should > use in excel. What he wants is, that he collects > all the excel-lists and rewrite the changed records he got > back from the excel-lists and transferring them (via CF) to > MS-Access. Some aspects how to do this are clear, but can > somebody give me some advice on what the pitfalls are on > scripting those templates, maybe somebody who has done more > or less the same ? Would be great. Thanks. Uwe ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
