Q
Problem solve Get help with specific problems with your technologies, process and projects.

Agent to export data from a view on the Web into Excel

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.

  1. Placing this formula in an Action:
    @Command([ToolsRunMacro];
    "Export All To Excel")
    The Agent is called Export All To Excel
    
  2. The Agent consists of this info:
    Option Public
    Use "Export All To Excel"
    ________________________
    
    Initialize:
    
    Sub Initialize
     
     Call ExportViewToExcel("All")
     
    End Sub
    _____________________________
    
If you can guide me to a solution I'd appreciate it. Thank you.
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.

This was last published in February 2004

Dig Deeper on Lotus Notes Domino Agents

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

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 ...

SearchDataCenter

SearchContentManagement

Close