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

  • Thread starter Thread starter Harry
  • Start date Start date
H

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
 
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
 
Correct, I get the error messages, or the data remains formatted as it is
displayed in Excel.

thanks,
Harry
 
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.
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top