Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Pull Data From Non-Default Calendar (http://www.outlookbanter.com/outlook-vba/101244-pull-data-non-default-calendar.html)

eckert1961 March 23rd 10 04:38 PM

Pull Data From Non-Default Calendar
 
Hello,

I am running Outlook 2003 and I have a macro that pulls data from the
default calendar. I created a new calendar named "Instructor Schedule" which
is a subfolder under Calendar. I would like to change the code so that the
data is pulled from the new calendar. Currently I am using the following code.

Set colCal = objNS.GetDefaultFolder(olFolderCalendar).Items

What change would I need to implement to get my desired results? Thanks.

Regards,
Chris
--
Regards,
Chris

Ken Slovak - [MVP - Outlook] March 23rd 10 05:38 PM

Pull Data From Non-Default Calendar
 
Set colCal =
objNS.GetDefaultFolder(olFolderCalendar).Folders.I tem("Instructor
Schedule").Items


--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"eckert1961" wrote in message
...
Hello,

I am running Outlook 2003 and I have a macro that pulls data from the
default calendar. I created a new calendar named "Instructor Schedule"
which
is a subfolder under Calendar. I would like to change the code so that the
data is pulled from the new calendar. Currently I am using the following
code.

Set colCal = objNS.GetDefaultFolder(olFolderCalendar).Items

What change would I need to implement to get my desired results? Thanks.

Regards,
Chris
--
Regards,
Chris



eckert1961 March 23rd 10 07:18 PM

Pull Data From Non-Default Calendar
 
Thanks for the quick response Ken. That worked perfectly.
--
Regards,
Chris


"Ken Slovak - [MVP - Outlook]" wrote:

Set colCal =
objNS.GetDefaultFolder(olFolderCalendar).Folders.I tem("Instructor
Schedule").Items


--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"eckert1961" wrote in message
...
Hello,

I am running Outlook 2003 and I have a macro that pulls data from the
default calendar. I created a new calendar named "Instructor Schedule"
which
is a subfolder under Calendar. I would like to change the code so that the
data is pulled from the new calendar. Currently I am using the following
code.

Set colCal = objNS.GetDefaultFolder(olFolderCalendar).Items

What change would I need to implement to get my desired results? Thanks.

Regards,
Chris
--
Regards,
Chris


.



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com