+ Reply to Thread
Results 1 to 2 of 2

Create Appointment In Other User's Calendar

  1. 09-05-2016, 11:17 AM #1
    dsajones
    dsajones is offline
    Registered User
    Join Date
    11-07-2013
    Location
    Kidderminster, England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Create Appointment In Other User's Calendar

    Hi All,

    I'm going round in circles on this one. First you need to know that I'm programming in Excel 97-2003 format. Long story....... So I've picked up snippets of code from various forum posts and the following is working fine EXCEPT, the created appointment is in my default calendar rather than in the calendar of the other user. I know there must be some simple syntax error and I'm sure it must be related to the olAppointmentItem which is declared as a constant with a value of 1 but I just can't figure it out. Help would be very much appreciated!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-09-2016, 03:37 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Create Appointment In Other User's Calendar

    Hi dsajones

    You'll need to define the Calendar to populate. See Post #7 in this link. Need help adapting let me know.

    http://www.excelforum.com/excel-prog...-calendar.html
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Select calendar for new appointment
    By bigfishprf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2016, 12:41 PM
  2. Create Appointment/Task from Excel to Outlook with Non Default Calendar
    By slohman in forum Excel General
    Replies: 1
    Last Post: 07-06-2014, 07:37 PM
  3. VBA Recurring Calendar Appointment In Other Users Calendar
    By hobbiton73 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-20-2013, 04:27 AM
  4. VBA Recurring Calendar Appointment
    By hobbiton73 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-13-2013, 03:43 AM
  5. Exporting data from different worksheets to create a new oulook calendar appointment
    By battenborrow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2011, 08:53 AM
  6. VB an appointment into Vista's calendar
    By Mayweed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2011, 02:51 PM
  7. Creating an Appointment Calendar
    By vipjd39 in forum Excel General
    Replies: 3
    Last Post: 02-19-2009, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1