• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 808
  • Last Modified:

Suppress or auto reply to Lotus Notes dialog from VBA under Excel

I am entering reminders in Lotus Notes calendar using dates from an Excel worksheet.
I am using Excel 2003 and VBA with NOTESUIWORKSPACE to communicate with Notes.
I am taking data/dates from a worksheet and creating reminders on a notes calendar.

All is fine until the program encounters a (perfectly valid) appointment date that is in the past.
Notes pops up a dialog box which says  "This entry is being created in the past, Create anyway?" and the option to click 'yes' or 'no'

I either need to supress this message and let the entry continue of automatically. reply with 'yes'.

Is there a function similar to displayalerts = false under Notes?.. or does anybody have another solution to this.

  • 2
1 Solution
GlennJWalkerAuthor Commented:
Increased to 500 points for solution...

PK HariAPAC Financial ControllerCommented:
Ok, my thoughts...

Use the SendKeys method of VBA to pass an <Enter> key effect to the Notes window..

For example of this, look up here:

GlennJWalkerAuthor Commented:
Thanks for that.
As a newbie, I didn't know that sendkeys was an option.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now