Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can I create a calendar and import data from a table into it?
I have a Word Table that contains, among other items, dates (e.g, 5/14), day
of the week (e.g., Tues), and another column of data. Is there a way to created a monthly calendar that would use these three items and automatically create a calendar, entering the information in the column of date into the correct day of the month? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can I create a calendar and import data from a table into it?
Taking the question literally, it is possible. However, to my knowledge
there is no pre-packaged solution for anything like it. You would need these ingredients: - Choose or create a calendar template with the appearance you like. There are a lot of calendar templates at http://office.microsoft.com/en-us/te...043131033.aspx, and many of them are suitable for putting information into the date boxes (which are usually just table cells). - Write a macro to transfer the data from your existing document to a document based on the calendar template. Although you could perhaps get a starting point from Word's macro recorder, there are parts of it -- such as reading a date from the source document and determining from it which cell in the calendar is the corresponding one -- that cannot be recorded. For that, you'll have to learn something about programming in Visual Basic for Applications and how the "object model" (VBA's description of things in Word) works; or you can find someone who knows how, and have them write it for you. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. mjreale wrote: I have a Word Table that contains, among other items, dates (e.g, 5/14), day of the week (e.g., Tues), and another column of data. Is there a way to created a monthly calendar that would use these three items and automatically create a calendar, entering the information in the column of date into the correct day of the month? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Word Calendar to Outlook | Microsoft Word Help | |||
Import Outlook Calendar into a Word Calendar | Microsoft Word Help | |||
Import Outlook Calendar Appointments into a Word Calendar? | Microsoft Word Help | |||
How to import XML data into a Word document table | Tables | |||
Import csv data into a specifically formatted Word table | Tables |