No, not possible. It sounds like you're having a problem which is slighly different than I originally thought.
If its absolutely essential that the data is updated straight away, you could try VBScript. Just export the data as CSV and then use VBScript to read in the file and place the data into the correct cells using something like objXL.Cells(2,2).Value = var You could also probably use excel's COM methods to do it also, but its been a while since I've had to play around with COM. Mark -----Original Message----- From: Sam Clement [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 02:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: updating dynamic fields in excel I'm actually just using a web form and excel as the datasource. Is it possible to run excel on the client's browser and perform an datasource update from there? -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 3:38 AM To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: updating dynamic fields in excel I'm assuming you're viewing the spreadsheet via IE? If so my initial thoughts would be to hardcode a javascript refresh after running the query. Would that not do the trick? hth Mark -----Original Message----- From: Sam Clement [mailto:[EMAIL PROTECTED] Sent: 01 January 2000 10:53 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: updating dynamic fields in excel Not sure if anyone's had experience with this on this list but I thought it would be worth a try. I can update an excel sheet through a web form using an ODBC connection, but none of the dynamic cells in the excel sheet are updated when a new query is made. Is there any way to get excel to update itself without opening and closing the excel file? Longshot, I know... Cheers, Sam Clement ABOVE Studios Boutique Design Solutions 7 Sunny Place - Cascade Trinidad + Tobago - West Indies T: (868) 621 3626 W: abovestudios.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
