Greetings to all,

I am new to VB. In my VBA macro I am trying to access a data source(a text file) using the below code snippet.



Dim TESTING As String
..
..

TESTING = "M_1111" 'Accesing the value of M_1111 from data source
Selection.TypeText Text:=Chr(13)
Selection.TypeText Text:="TESTING"
Selection.TypeText Text:=Chr(13)



This works fine, if the value of M_1111 contains less number of characters. But if the value of M_1111 contains more number of characters, the value gets truncated upon accessing.

I don't know why this truncation is happening. Is there any maximum for the number of characters that can be accessed?

Any help appreciated.

Thanks
priby