I have a spreadsheet that formats a character in my FEX output to an Alt+Enter to force carriage-returns in the cells. If I saved this macro to an "empty" spreadsheet and wrote (APPEND? my weekly updates to this file, could I preserve and thus use, my macro? If so, please do tell ...Thanks

I don't believe that you can do that, however you can create your Excel file as a Web archive (.mht) and then save your output to that. There are several posts that tell you how.

One thing to remember is that the Web archive must have at least two worksheets within it. I use this method to control all the formatting of a worksheet including print areas, zoom levels, borders, column widths etc. etc. I follow all the formatting up with a deletion of the worksheet that is not required so that the final Excel workbook has only the one sheet.

T

Thank-you for the suggestion. Do you have any sample code I could see? Im currently on v 5.2.4 do you know if the method you're referring to would be supported in my version?

You need version 7.1 to be able to take advantage of Excel templates (web archives).

For examples use the find function and search on "web archive".

T