View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dreiding Dreiding is offline
external usenet poster
 
Posts: 80
Default Excel 2003 & XML Question

I've been able to create an excel XML export function. The first line of the
file is <xml version="1.0" ?. The process works well except when some
non-xml acceptable characters are used. The export is always fine, but when
I view the xml file in any browser, the browser returns with errors. These
errors are due to have unacceptable characters. Ugh!

Are there any functions or method I can use to filter (replace) the bad
characters as the xml file is written?

Thanks,
- Pat