View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smcclure smcclure is offline
external usenet poster
 
Posts: 1
Default HTML/XML Import Error -ExcelName

I'm trying to get Excel to print titles on every page when a web page
is converted to Excel.

Here's the XML:
..... </x:ExcelWorkbook
<x:ExcelName
<x:NamePrint_Titles</x:Name
<x:SheetIndex1</x:SheetIndex
<x:Formula=LIDS_Report!$8:$8</x:Formula
</x:ExcelName
</xml<![endif]--

It works but pops up an import error. The error is logged as:

htmlErr.log-----------------------------------------------
XML ERROR in Excel Name
REASON: Bad or Missing Tag(s) or Value(s)
ACTION: Aborting current XML group
FILE: C:\DOCUME~1\smcclure\LOCALS~1\Temp\mso28D.aspx
GROUP: ExcelName
TAG: ExcelName
htmlErr.log-----------------------------------------------

Any ideas on how to overcome this?

Thanks,

smcclure