Thanks for the responses. Bascially here is my problem: I have a page that I use to export a list of parts to an Excel file. I'm using the CF_HTML2EXCEL tag that connects to the Excel COM object. What it does is save the HTML between the start and end tags as a temporary HTML file, open it up in Excel and do a SaveAs excel file.
This has worked like a charm until I realized that if the part numbers (in the dB as VarChar) are all-numeric then when Excel opens the file it is converting all of the cells to General format and then when it sees the numeric value, converting the general to a number. Where the part numbers are 0004567 and 000000 (the client's way of saying "No Part Number"), they get to the HTML file correctly but then in the opening, excel works it's magic and I get 4567 and 0. I figured if I could write the file with some control character and then execute a Replace for the control character to the ' character (which, in Excel, denotes a force-text) then it will work. I've done it manually, recording a macro, and I can't get the Replace funciton to run when I try and do it through the Com object. The reason I have to do the replace is because the auto-conversion is happening the miunute Excel opens the file. Thanks again! Hatton Philip Arnold - ASP wrote: >>I'm wondering if I'm posting a question in the right place. >> >>Yesteday I posted an Excel COM object question (interacting >>with Excel >>via it's COM object using CF... I need to run a Replace and >>can't get it >> to work right). I posted the question to CF-Talk and also >>on CFComet.com. >> >>Any ideas where else I should post it or should I just shutup and be >>patient? >> > > What's the question? I'm OK with Excel COM (not touched it for a few > months, but I should be able to dig it out) > > 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. > ********************************************************************** > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
