I am somewhat inexperienced at working with agents and have been trying to export data from a view on the Web (from a browser) into an Excel spreadsheet. I have found agents "out there" that claim to do this, but none of them seem to work. Here's one LotusScript example of what I have tried.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
- Placing this formula in an Action:
@Command([ToolsRunMacro]; "Export All To Excel") The Agent is called Export All To Excel
- The Agent consists of this info:
Option Public Use "Export All To Excel" ________________________ Initialize: Sub Initialize Call ExportViewToExcel("All") End Sub _____________________________
Read the article Keeping the boss happy on Codestore.net. I tried the examples there some time ago, and they did work.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Lotus Notes Domino Agents
Related Q&A from Jens Bruntt
Web Development expert Jens Bruntt offers suggestions on how to programmatically copy and hide attachments in Lotus Notes rich-text fields.continue reading
Learn about an add-on Domino developers can use to programmatically edit rich-text field tables from within the Lotus Notes client.continue reading
Web Development expert Jens Bruntt outlines three potential issues to consider when troubleshooting Lotus Notes Domino tabbed table problems.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.