Create an automatic scheduled view export in Excel

I want to create an automatic scheduled view export in Microsoft Excel format. This works from the File -> Export...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

menu, but Formula language can't exist in a scheduled agent. I'm not familiar with the Lotus object model.

Menu actions are part of the user interface (UI). Agents that run in the background can't interact with the UI, because such a UI doesn't exist.

It's possible to create an automatic scheduled view export in Excel with LotusScript code using Microsoft Excel COM classes. It's not the easiest thing in the world to pick up, but you can find sample code on the Lotus Sandbox site and adapt it for your Lotus Notes view.

You can also search Microsoft's Developer Network (MSDN) site for a reference of adaptable Microsoft Excel COM classes.

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from SearchDomino.com:

10 tips in 10 minutes: Top 10 LotusScript tips
Learning Guide: LotusScript
Tip: How to export Lotus Notes views to a Microsoft Excel database
Tip: Import data from Excel to a Notes form with LotusScript
Reference Center: LotusScript

Dig Deeper on LotusScript

Can I create and copy Microsoft Excel spreadsheets with LotusScript? Learn how you can use LotusScript and OLE to create and populate Microsoft Excel spreadsheets, as well as a little bit about Lotus Symphony.

Mass-input form uses LotusScript to ease large-scale employee moves Use this LotusScript button and Lotus Notes form with a spreadsheet-style interface to enter a high volume of records. This tip is helpful during a large-scale office move and can save your help help desk team time and trouble.

Code exports Lotus Notes data to an OpenOffice Calc spreadsheet The ability to transfer Lotus Notes data from a database to an Excel spreadsheet has been available for some time. If you're using OpenOffice.org Calc spreadsheets, however, you'll need to use this LotusScript code instead.

Top 10 Lotus Notes/Domino coding and development tips of 2008 We've compiled our most-viewed Lotus Notes/Domino coding and development tips of 2008. Discover how to use LotusScript to sort a document selection, programmatically replace the design of a Lotus Notes database, clear a local cache using LotusScript and more here. You'll see why these development tips caught our readers' eyes in 2008.

Alternate version of @Command forwards subform via LotusScript The @Command([MailForward]) function lets you place an UI document's contents into a mail memo and forward it. If you only want to forward a portion or subform of the UI document, this tip can show you how, using a LotusScript alternative.

How to use LotusScript to modify a Lotus Notes view selection If you've been looking for a way to use parameters to limit a Lotus Notes view selection, you're in luck. This tip gives the LotusScript and a few examples to help you.

Have a question for an expert?

Please add a title for your question

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

Meet all of our Domino experts

View all Domino questions and answers

Please create a username to comment.

What admins need to know about Azure Stack HCI

How to manage Exchange hybrid mail flow rules

How to repair Windows Server using Windows SFC and DISM

iSeries tutorials

V6R1 upgrade planning checklist

Connecting multiple iSeries systems through DDM

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

Dig Deeper on LotusScript

Related Q&A from Brad Balassaitis

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.