Tabs/sheets not showing

**tiggy00** · 03-25-2010, 03:44 PM

I'm writing a program on an IBM mainframe using Cobol to create a file that will be a fully formated excel spreadsheet with 12 tabs/sheets. All data is supposed to be formated as are the cells. The problem is, when I try to open it, I only get one tab/sheet with the name being that of the file itself, and all of the data is listed on the single sheet. However, if I make a slight change in the code, I get all of the tabs/sheets, but absolutely no data and an error saying "unknown".

This code gives me just one sheet wtih all data on it:

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:x=3D"urn:schemas-microsoft-com:office:excel"
xmlns=3D"http://www.w3.org/TR/REC-html40">

This code gives me all 12 sheets with no data:

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns=3D"http://www.w3.org/TR/REC-html40">

I can clearly see that the 3D on the third line is the difference. What I'm wondering is how to get around this so I can see all of the data on the 12 designated sheets.

Has anyone ever seen this before or have any idea how to get around this?

Thanks in advance.

**royUK** · 03-25-2010, 03:55 PM

That's not VBA code

**tiggy00** · 03-26-2010, 07:27 AM

I understand it is not VB code. If you take an excel spreadsheet and do a save as and select other formats, then set the type to Single File Web Page (.mht), it will allow you to see the back end code for the spreadsheet. This is where this code comes from.