Hi Simon, >On 11 May 2015, at 3:25pm, Jean-Christophe Deschamps ><jcd at antichoc.net> wrote: > > > Isn't that the actual size limit of Excel strings? > >Sort of. Although Excel cells can contain text longer than 255 >characters, VBA functions ignore text parameters after the 255th >character. This is because VBA, when originally written, used >Pascal-type strings internally. > >Simon.
Yes, I meant "using either VBA or COM objects". People regularly complain that they hit this limit when using Excel with AutoIt (the communication uses COM). JcD