Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
mjreale mjreale is offline
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Word Calendar to Outlook Dan Microsoft Word Help 3 January 11th 08 03:42 PM
Import Outlook Calendar into a Word Calendar jstephen Microsoft Word Help 0 November 3rd 06 03:02 PM
Import Outlook Calendar Appointments into a Word Calendar? Lynn Microsoft Word Help 1 January 23rd 06 10:08 AM
How to import XML data into a Word document table G Stark Tables 2 June 15th 05 10:09 AM
Import csv data into a specifically formatted Word table Pat Dools Tables 7 February 28th 05 01:03 PM


All times are GMT +1. The time now is 09:47 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"