Ask the Expert

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: