I remarqued something very strange.

In Word (2000 & 2003) the "I" line is greater than the "M" line when viewing
and printing.
In Excel when viewing the "M" line is greater but when printing the "I" line
is greater like in Word !!!

Buggy Excel :)

"Seb" a écrit dans le message de news:
...
Hello,

I am merging documents with fields from an Excel sheet.
I need to put some text (from Excel) into boxes pre-printed on the paper,
the boxes have fixed sizes.

The problem is that some datas in the Excel sheet doesn't fit in the
boxes, and because I am using non-fixed fonts the values of the datas are
changing the width of the text (MMMMM vs IIIII).

My goal is to do a macro (in Excel or Word) to tell me which records
doesn't fit in a XX centimeters box when using a specific font/size (and
then I can modify manually the datas in Excel when it's too large).

I searched how to get the real printed width (or any value with a fixed
ratio value/real_printed_width) of a string but I can't find any
information about it.

Thank you VERY VERY much in advance, ANY help is REALLY appreciated.
Seb.

PS: sorry for my bad English, it is not my first language.