The trouble is that some of the expected formatting within the Excel spreadsheet is lost. For example, we are loosing bold fonts and column widths that are set by the Excel macro. Other results from the macro are fine, such as the addition of new columns, computing totals based on the sum of columns and so on.
Any thoughts on why we are losing some of the results from the Excel macro?
What happens when you run the macro from within Excel? Do you get the same results (i.e., computing results, adding columns, but no formatting)?
Have you recently upgraded the version of Excel that you are using? I noticed that you specifically mentioned "macro." Did the macro originally come from an earlier version of Excel? Be aware that some macro commands have been "deprecated" by Microsoft during version upgrades, and you may be calling a command that is no longer valid in VBA code in your excel macro.
This is most likely, in my experience, to be the issue, rather than anything you are doing from Domino, especially since some of the code is executing.
This was first published in June 2005