can someone tell what the maximum length a String variable in Office 2007/VBA is?
I run into the following problem. I read a file (approx. 1mln characters) and only about 500k character are read/put into the String variable. Is this because of a maximum numbers of characters in a String object?