No subject

There are two kinds of strings: variable-length and fixed-length strings.
A variable-length string can contain up to approximately 2 billion (2^31)
characters.
A fixed-length string can contain 1 to approximately 64K (2^16) characters.

In a application I use a text file is placed into a string variable defined
by
Public myString as String.

 I was under the impression that this line defined a variable length
string, but ran into a text file of approximately 5mb. This file would not
fit. The file contains less than 100k characters. So I asked around the
office and was told that actually the variable length string with 2bill
char limit referenced here is for VB only, and that VBA has a hard limit of
64K chars.

The actual error is:
Run Time Error 14: (out of string space)

Can anyone confirm this, or have any thoughts on the subject?