Macro to create calendar in Excel

[Brenda]

Hello,

Being dissatisfied with the calendar view that is available in MS Project, I
have been asked to see if I can find a way to generate a calendar in Excel (I
suppose it could be in Word as well, though Excel seems to make more sense.)
I have a number of macros in MS Project that were handed down to me that
export task information into Excel, so I have had some experience with those.
I've also been able to find a macro for Excel that can take some information
(task name and event date) an create a calendar in Excel that puts the task
on the appropriate date (I apologize that I do not remember who had provided
a link to that code, but it was someone from the group here.) I only
understand VBA well enough to tweak what I have, not well enough to come up
with something new. So, after that LONG story, here's what I really need:

- Calendar format
- Shows tasks in a bar format across all of the days that are applicable for
that task
- Be able to fit all tasks for a given month into that month's view (MS
Project only allows a certain number then the rest are thrown onto an
"Overflow" listing)

Does anyone have anything like that already created?

Thanks much!
Brenda

 

[TechGuy]

Rather than creating a macro to create the calendar & import the data,
you may want to consider the following:
Export MS Project to MS Outlook Calendar. This can be done using CSV
export & may require some data massaging (Google 'Microsoft Project to
Outlook' for more info).
From there you can print to a variety of formats in MS Outlook.

If you still rather have a editable Excel Calendar, you can use
WinCalendar to import from Outlook Calendar to Excel format.
Alternately if you rather not use Outlook, then perhaps save some time
by writing code that imports directly to free Excel calendars found
here: http://www.wincalendar.com/excel-calendar-template.htm

Best Regards,
Mike Hampton