A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Calendar
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

...can my public folder calender's events be linked to spread shee



 
 
Thread Tools Display Modes
  #1  
Old September 30th, 2005, 08:48 PM
Dr. Darrell
external usenet poster
 
Posts: n/a
Default ...can my public folder calender's events be linked to spread shee

I would like to build a gant chart in excel. The events that will be depicted
on my chart are already entered in a calender in a public folder.

Can I link the events listed in the calender to cells of the Excel
Spreadsheet?

Respectfully,
Darrell
  #2  
Old October 2nd, 2005, 05:25 PM
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default

I tried to build a Gantt chart from a calendar once in Excel and it took =
me 3-4 hours to get a pretty unsatisfactory result. And that was using =
built-in export to Excel, not writing code, which is what you'd have to =
do to get any live "link." I just exported data from the calendar folder =
to Excel, then played around with the technique in KB article 152820

--=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dr. Darrell" wrote in message =
...
I would like to build a gant chart in excel. The events that will be =

depicted=20
on my chart are already entered in a calender in a public folder.=20
=20
Can I link the events listed in the calender to cells of the Excel=20
Spreadsheet?=20
=20
Respectfully,=20
Darrell

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Free/Busy "Add public folder" not available???? acole006 Calendar 2 July 8th, 2005 05:45 PM
tried to transfer messages-messed up outlet express Leonard F Kiesling Outlook Express 10 May 22nd, 2005 04:40 AM
Public Folder displaying unread number incorrectly Tim General Discussion 1 January 21st, 2005 11:44 PM
completely delete office2000 jason Setup, Installing & Configuration 1 May 28th, 2004 10:08 AM
office 2000 remove tools bud Setup, Installing & Configuration 1 May 27th, 2004 10:40 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.