Get National Calendar Holiday with VBA

  • Thread starter Thread starter Joao Rodrigues
  • Start date Start date
J

Joao Rodrigues

Hi all,

how can i "see" with VBA, if a date is a holiday in the
National Calendar set in Outlook 2000 user mailbox,
Calendar Options ?

I've been watching in the Outlook.Application objects and
collections and I'ved trie to set a PropertyPages
collection but i'm getting no where...

Thanks in advance, for any clues on this subject.

Joao.
 
If the user imported holidays using Outlook's feature for that, each of
those holiday items will have a category of "Holiday." You could, therefore,
use Find or Restrict to get the items for a particular date (see
http://www.outlookcode.com/d/finddate.htm) then check the value of the
Categories property for each one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

National Holidays - Dates 2
Outlook Outlook 2007/Exchange 2010 Shared Calendar 1
National Holidays 2
Holidays on calendar 1
Excel Worksheet_BeforeDelete code not working as expected. 1
Outlook National Holidays 2
add an appointment for a custom calendar, vba excel 2
Getting values of custom categories set on Calendar folder 2

Back
Top