I have a focexec that calls several report focexecs and saves their output into a compound Excel workbook. This workbook provides the data to feed individual worksheets in another Excel workbook. The problem is the compound Excel workbook is a .xht file, and the cell references in the other Excel workbook which is a .XLS file can't access the .xht file.

Any suggestions on how to get the linkages to work? Manually opening and saving the .xht file into a .xls file is not an option, since this is to be an automated process.

Thank you,

John

This message has been edited. Last edited by: Kerry,

Unless there is a utility out there to convert, I would suggest using FORTMAT EXCEL for each worksheet, but you would have to change your references. And its only version 2.1 of excel

Are you linking to the xht file ?

If so, try changing the extension to xls.

John

WebFOCUS on a Windows platform?

Got Excel on the server?

Take a look at Tony A's post.

[CLOSED] creating .xls file -- is it XLS or XHT with a .xls extension?

Waz WebFOCUS Excel format will not work it's a compound doc.