Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
Can this be done in Word?
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
Hi ?B?V29yZCBDYWxlbmRhcg==?=,
Can this be done in Word? Hard to say without knowing more details. Most likely it would require a (non-trivial) macro solution, though. (Note: Word, itself, has no calendar functionality. Calendars are often constructed using a Word table. Outlook has real calendars.) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
Column A cells contain "event" information and Column B Cells contains
corresponsing dates. I wish to import the data from Excel into Word in the form of a calendar with the events listed in the appropriate date boxes. I was trying to import the information into another program but that program does not allow the calendar fields to have multiple collumns, which I need as some of the dates have too many events to list in a single column. I have achieved the desired results in the past by manually typeing the information into the calendar fields, but I was hoping to simplify process. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
I tried to import the information into an Outlook calendar with limited
success. I've arrived at the same point I did before. I need to format individual date fields in order for all events to be visible and therefore printable. Can this format change be achieved in Outlook? |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
Hi ?B?V29yZCBDYWxlbmRhcg==?=,
I tried to import the information into an Outlook calendar with limited success. I've arrived at the same point I did before. I need to format individual date fields in order for all events to be visible and therefore printable. Can this format change be achieved in Outlook? You'd need to ask this in an Outlook newsgroup... Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
Hi ?B?V29yZCBDYWxlbmRhcg==?=,
Column A cells contain "event" information and Column B Cells contains corresponsing dates. I wish to import the data from Excel into Word in the form of a calendar with the events listed in the appropriate date boxes. I was trying to import the information into another program but that program does not allow the calendar fields to have multiple collumns, which I need as some of the dates have too many events to list in a single column. It could certainly be done - no question. But would definitely require programming a macro. Since this newsgroup is targeted at end-users, your best strategy would be to take this request to a word.vba newsgroup. Before you do, go to the word.mvps.org website and read some articles under the Macros/VBA topic http://word.mvps.org/FAQs/MacrosVBA/index.htm Besides any beginner-level articles you feel appropriate, read about "Working with Tables" and "Control Excel from Word" link on this page http://word.mvps.org/FAQs/OfficeInterdev.htm This will give you the background you need to get started. Then you can ask very targeted questions. (Requesting people to design an entire application - something they usually get paid to do - often puts them off). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Excel file into a Word Calendar
I haven't had a chance to try your suggestions yet, but none the less, I
appreciate your help Cindy M. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing an Excel spreadsheet into Word | Microsoft Word Help | |||
Importing excel file into Word without the grid lines | Microsoft Word Help | |||
Importing Outlook Calendar Data Into Word Template | Microsoft Word Help | |||
Importing Excel into Word. | Tables | |||
Importing an excel file (each cell is formatted as a label) into . | Mailmerge |