ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print_Titles and mutiple <table tags: problems during load (https://www.excelbanter.com/excel-programming/324803-print_titles-mutiple-table-tags-problems-during-load.html)

William

Print_Titles and mutiple <table tags: problems during load
 
I'm generating an Excel HTML/XML worksheet. Everything works fine until I try
to have multiple <table tags and configure the Excel "Print titles"
option... when I open the Excel HTML/XML document, I get an error window
saying "Problems during load" and in the message area "Excel Name". The code
I'm using for "Print Titles" is as follows:
<x:ExcelName
<x:NamePrint_Titles</x:Name
<x:SheetIndex1</x:SheetIndex
<x:Formula=Sheet1!$1:$2</x:Formula
</x:ExcelName

And the other element is having more than one <table tag:
<table
misc tags, data...
</table
<table
....more tags, data
</table

If I remove either all the <Table</table tags except for the outer pair OR
remove the "Print Titles" code, the HTML/XML Excel document loads fine.
Neither of which are options. Anybody know what can be done to fix this
problem?

Many thanks.


All times are GMT +1. The time now is 10:13 AM.

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