Rich, I'm interested in seeing the macro, especially the gif export part. I am also wondering if people are using the MSChart object for this task, without Excel. Wouldn't this be less overhead than opening excel? Or does that not factor in if excel is already running on the server? Mark Mark Wimer American Bird Conservancy, c/o USGS-Patuxent Wildlife Research Center 12100 Beech Forest Road, Laurel, MD 20708-4038 Ph: 301-497-5596 Email: [EMAIL PROTECTED] Aha. If anyone is interested, I wrote a macro to handle the data > chart creation and gif export that runs whenever a certain cell's value changes. Through CFOBJECT I'll see if I can insert data - hence triggering the macro, exporting the gif. Then free the connection, move the file using cffile (or set the macro to save the gif in the webroot) and serve the gif using cfcontent or something similar. Just got to get it working now, but the theory is so far sound unless anyone can spot any glaring holes. ;) ------------------------------------------------------- Rich Wild Senior Web Designer ------------------------------------------------------- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. ------------------------------------------------------- > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 16 November 2000 07:59 > To: CF-Talk > Subject: export excel charts - COM and CF > > > > Has anyone tried the following: > > Connecting to an instance of excel thru com, inserting data, > running a macro > on that inserted data which creates a chart based on that > data, then exports > the chart as gif - then tidying up (close com connection, use > cffile to move > gif to webroot and serve). > > I'm not particulary worried about the first bit or the last > bit, but the > firing off the macro and exporting is the bit that I'm > seeking help about. > Nate Weiss had some handy tips about ensuring that the macro > security is set > to the proper level for the NT account that CF runs under, > which wasn't > something I had considered quite frankly... > Are there any other things I should be aware of? Opinions on > the efficiency > of such a task to serve up a few dynamic gif reports? (I've > looked at the > various graphing tags and none of them are suitable (read > limited) , and > cfx_graphicsserver is too pricey an option) > > Help appreciated. > > :) > ------------------------------------------------------- > Rich Wild > Senior Web Designer > > ------------------------------------------------------- > e-mango.com ltd Tel: 01202 587 400 > Lansdowne Place Fax: 01202 587 401 > 17 Holdenhurst Road > Bournemouth Mailto:[EMAIL PROTECTED] > BH8 8EW, UK http://www.e-mango.com > -------------------------------------------------------------- > ---------------------------------- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
