+ Reply to Thread
Results 1 to 4 of 4

Creating and Naming New Outlook (or other) Calendars?

  1. #1
    Registered User
    Join Date
    11-09-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    21

    Creating and Naming New Outlook (or other) Calendars?

    I have created a Gantt worksheet which creates a chart which I can print and hand to contractors for scheduling tasks within projects.

    Using the same information I want to create calendar events in a new calendar (separate from my default) in Outlook (or alternative) which will be named according the client, i.e. one calendar per project: Project1, Project2 etc.

    It would help me greatly when scheduling my staff and resources and my own time, if I can overlay projects with my own calendar when required.

    I do know how to add appointments to my main calendar but this is not my objective in this query.

    I know that on this forum, some posters (including myself) can ask daft or inane questions through naivety, but I would appreciate any feedback whatsoever, even if it is to tell me that the above is impossible.

    Nicky

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Creating and Naming New Outlook (or other) Calendars?

    You can create as many new calendarmaps/folders in your account as you please (select map, mouse rightclick, new map/ calendar items/name/ OK)

    In VBA:

    Please Login or Register  to view this content.
    Last edited by snb; 02-01-2011 at 09:18 AM.



  3. #3
    Registered User
    Join Date
    11-09-2010
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Creating and Naming New Outlook (or other) Calendars?

    Thanks snb, this is great.

    I have this code to create 1 of around 30 possible tasks. At the moment the items are still being created in the default calendar: how and where do I reference the new calendar name?

    Please Login or Register  to view this content.

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Creating and Naming New Outlook (or other) Calendars?

    Please Login or Register  to view this content.
    NB. I hope you realize that the introduction of the new calenderfolder needs to be executed only once. That's why I put it in a separate macro.
    NB2 I introduced some variation in describing 'ranges'.
    Last edited by snb; 02-01-2011 at 02:09 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1