Q

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

Dig deeper on Lotus Notes Domino Administration Tools

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close