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.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
Dig Deeper on Lotus Notes Domino Administration Tools
Related Q&A from Mathew Newman
SearchDomino.com Sametime administration expert Mathew Newman explains-step-by-step how to enable communication between multiple Lotus Sametime ...continue reading
If Lotus Sametime users on different "home" servers cannot see each other online, you may need to change your Sametime server awareness by creating ...continue reading
SearchDomino.com's Sametime administration expert Mathew Newman offers advice to a Lotus Notes administrator looking for resources for deploying ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.