• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 804
  • 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.

Thanks.
0
GlennJWalker
Asked:
GlennJWalker
  • 2
1 Solution
 
GlennJWalkerAuthor Commented:
Increased to 500 points for solution...

Thanks.
0
 
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:
http://www.tek-tips.com/faqs.cfm?fid=5037
http://support.microsoft.com/kb/213815/en-us

Cheers,
P.K.
0
 
GlennJWalkerAuthor Commented:
Thanks for that.
As a newbie, I didn't know that sendkeys was an option.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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