Hi Folks, I am trying to figure out how to go about taking data pulled from a MSSQL DB and writing it to an xls file, naming it and saving it to a specific directory with minimal user action. I know how to go about basic exporting to xls using <cfheader name="Content-Disposition" value="filename=IPAddresses_#ThisFile#.xls" /> <cfcontent type="application/vnd.ms-excel" /> but this requires more user interaction to save it to a specified directory. I'd like to be able to do it all in code in the simplest manner possible ... if possible :) I'm running CFMX7 Standard and Windows Server 2003, MSSQL 2000. The simpler the better for a slow mind here :)
TIA Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3465 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
