>I think the field width is based on the current width of the column. Try before Save
oSheet.Range("A:Z").EntireColumn.AutoFit()
>
I've re-tried and it doesn't work :( I'll resort to my original solution of double width, but now I'll try to make it triple <g>
Hmm, triple worked better but not quite. I now have "The claim/line has been denied.Cannot provide further status electronica" and the original text is "The claim/line has been denied.Cannot provide further status electronically. Claim may be denied"
So, I would try 5 times, this way it definitely would work <g>
If it's not broken, fix it until it is.
My Blog