Using Lotus Script to display a message in Excel.

Posted on 2007-07-26
Last Modified: 2013-12-18

I have written some lotus script that exports a view to excel and everything works fine.  The last thing I need to complete the project is to inform the user that the export is complete.  Does anybody have any lotusscript that will display a message in excel?????

I am using Notes 6.5


Question by:rowdy_laxman
    LVL 19

    Expert Comment

    xlApp.StatusBar ="Completed"
    LVL 22

    Accepted Solution

    When I program for Excel, I normally use optimization techniques to make the export run faster, like hiding the Excel window and disabling screen updates in Excel.  Then, when my code has finished, I display Excel and make the sheet active.  This popup effect is normally just what the users want to see.  I'll add that printing a message to the status bar is still a good idea.  In fact, I would probably print the message to both Excel and Notes.  However, be warned that the user may not have the status bar displayed in Excel.
    LVL 31

    Expert Comment

    Bill is refering to primarily to Application.Visible = False, which is very inefficient (screen update ofccur).  You can also further optimize by temporarily turning off other automatic updates such as automatic calculations (Applicaton.Calculation).
    LVL 31

    Assisted Solution

    Oh, FYI, you might want to simply display your I'm don emessage in NOtes instead, by doing this:

    .Visible = False
    Msgbox "Export complete, click OK to display in Excel"
    .Visible = True
    ActivateApp "Microsft Excel - " & fileName

    Notes remains in the foreground until this completes

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now