Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Passing text fields from Excel
I am trying to copy my Excel gradebook into Word documents with
mailmerge. I found that I had to take the data through a converter to get it to format the percentages in my spread sheet correctly. When I use ODBBC it gives millions of decimal places and when I use DDE it mixes up some fields. I decided to use the converter because that worked the best. Then I added a field that contains the letter grade which is generated by a VB function as text. The text does not show up in the Word document. It just appears as an underline. When I tried earlier to display text cells that I read from another cell in the spreadsheet it had the same problem. What am I missing? I feel like I can't win. I am using Office XP SP1 and Windows Home XP SP2. |
#2
|
|||
|
|||
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP wrote in message ups.com... I am trying to copy my Excel gradebook into Word documents with mailmerge. I found that I had to take the data through a converter to get it to format the percentages in my spread sheet correctly. When I use ODBBC it gives millions of decimal places and when I use DDE it mixes up some fields. I decided to use the converter because that worked the best. Then I added a field that contains the letter grade which is generated by a VB function as text. The text does not show up in the Word document. It just appears as an underline. When I tried earlier to display text cells that I read from another cell in the spreadsheet it had the same problem. What am I missing? I feel like I can't win. I am using Office XP SP1 and Windows Home XP SP2. |
#3
|
|||
|
|||
Thanks for the reference. I found it in a previous note, possibly from
you. I tried to use DDE and it seemed that it was switching some of the fields - maybe I had them named badly. I am using the "via converter" option and it seems to work fine for numeric fields and ones where text has been typed in. The fields where I linked to a text field or used a VBA macro to generate it do not appear at all. If I use ODBC they appear fine but then the floating point fields have millions of decimal places and I can't control it. I finally just typed the generated text fields (letter grades) by hand in the output. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel text displays incorrectly | Microsoft Word Help | |||
Styles, text fields and protection problem. | Page Layout | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Outline | Page Layout | |||
Referencing Text fields in tables | Tables |