:P No, I'll fully admit that you told me how to do the replace in the COM object, but ya didn't post it here ;)
For those who might need this in the future: The end answer was to call the Replace function correctly and select the Cells object propperly. objRange = objExcel.Cells; objRange.Replace(What, With); In my case I ended up saving a CHR(3) in the file, so I have objRange.Replace(CHR(3), "'"); Since the data is being manipulated within Excel itself, this causes the cell to force-format to text from that point on, which is what I needed. And yes, Phil told me the solution. Hatton -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 5:45 AM To: CF-Talk Subject: RE: cf_HTML2Excel Question > Thanks for the reply Joe, I found a solution within the tag itself. Oh yeah, YOU found the solution <g> Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
