Linking data from an Excel Cell to Word, and formatting it in Word

[Harry]

Hello All:

I have an Excel cell I am linking to Word via a field:

LINK Excel.Sheet.8 ExcelSheet.xls "Worksheet!R6C10" \a \f

The data in the Excel cell is formatted mmm-yy (yes it's a date), and it
must stay that way.
However, I'd like to format the same data in Word as
MMMM YYYY (in other words, the full Month name and 4 digit year).


Can this be done?

thanks,
Harry

 

[Suzanne S. Barnhill]

Yes, see http://www.gmayor.com/formatting_word_fields.htm

 

[Harry]

I've tried
{ SET A "{LINK Excel.Sheet.8 ExcelSheet.xls "Worksheet!R6C10" }" }{A \@
"MMMM yyyy"} but I get a "Error, no bookmark",

and i've tried

{ LINK Excel.Sheet.8 ExcelSheet.xls "Worksheet!R6C10" \@ "MMMM yyyy"}

but the linked data remains in the format the Excel cell uses.

What am I doing wrong?

thanks,
Harry

 

[Suzanne S. Barnhill]

I assume you used F9 to update the field?

 

[Harry]

Correct, I get the error messages, or the data remains formatted as it is
displayed in Excel.

thanks,
Harry

 

[Suzanne S. Barnhill]

I'm not sure why this wouldn't work, but I'm not familiar with LINK fields.
The Help topic on that field, though, offers a switch that governs
formatting. I suspect that this refers to, say, font formatting, but you
might try using it to see if it makes a difference.

 

[Graham Mayor]

The following should work

{ Quote "{LINK Excel.Sheet.8 ExcelSheet.xls "Worksheet!R6C10" }" \@ "MMMM
yyyy" }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>