H IS AGENT IS USED TO EXPORT THE CURRENT VIEW DATA TO EXCEL- Procedure : 1. Create New Lotus Script Agent with Menu Selection property 2. Copy Below Complete Lotus Script Code and Paste it in Initialize 3. Save this agent with proper name 4. Close the agent and goto any view in your database 5. Find your agent name in "Action" Menu and run it. 6. Excel File will be ready to desktop. 7. Done. EXPORT TO EXCEL ANY VIEW : Const visualproc = True 'Display Visualvisual progress bar true = yes /false = no Const AppConst = "Excel.Application" Const AppConst2 = "Excel.Application.8" Const NPB_TWOLINE% = 1 ' Procedures in nnotesws.dll (undocumented!!). Dim db As NotesDatabase Dim view As NotesView Dim doc As NotesDocument Dim nc , nl , nmore Dim selList ( 0 To ...
Comments
Post a Comment