Excel macro on Domino server changes some formatting

I have a Domino agent running on a Windows 2000-based Domino 6.5.3 Server that successfully initiates a custom macro within an Excel 2000 spreadsheet (Excel is installed on the server). The Excel macro basically reformats data that currently exists on the corresponding spreadsheet.

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?

Since your macro is executing SOME of it's required output successfully, I would be inclined to investigate that macro in more detail.

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

Back to top