> (*sputters*) (*blinks*) You mean I spent 5 hours trying 30 different
> ways and it's that easy?!
Yups <g> some COM stuff is stupidly easy, others are REALLY annoying...
> What I'm actually going to to is
>
> ObjRange.Replace("#CHR(3)#", "'")
>
> That way I don't run into anything that someone would have in a text
field.
Shouldn't that be
ObjRange.Replace(CHR(3), "'")
Remember that once it's in text format, it's left in text format no
matter what you do to it, so if you start your fields with something
really stupid like "&*&*&*", then if you remove that from &*&*&*00005,
it'll stay as 00005 and not turn into 5
Also, I'd avoid using special characters as Excel may strip them on the
way in
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.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
