ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HTML/XML Import Error -ExcelName (https://www.excelbanter.com/excel-programming/314359-html-xml-import-error-excelname.html)

smcclure

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




All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com