Stupid question

[carlos_ray86]

Is text considered a string automatically by VBA? I imported a text
file and I'm wondering is that text automatically a string

 

[Guest]

string is the data type in VBA. there is no text data type.

 

[Guest]

Don't know if this helps, but what I get from it is, that text as such might
not be used as a string data type. You can take it for what it is worth. It
is a Microsoft definition.

data type:
The characteristic of a variable that determines what kind of data it can
hold. Data types include Byte, Boolean, Integer, Long, Currency, Decimal,
Single, Double, Date, String, Object, Variant (default), and user-defined
types, as well as specific types of objects.

So if text is not one of the other eleven categories, it is probably string.

 

[carlos_ray86]

Don't know if this helps, but what I get from it is, that text as such might
not be used as a string data type. You can take it for what it is worth. It
is a Microsoft definition.

data type:
The characteristic of a variable that determines what kind of data it can
hold. Data types include Byte, Boolean, Integer, Long, Currency, Decimal,
Single, Double, Date, String, Object, Variant (default), and user-defined
types, as well as specific types of objects.

So if text is not one of the other eleven categories, it is probably string.





- Show quoted text -

Thanks for the help I thought it would be considered a string and now
that I'm doing more stuff it does default the imported text to be a
string. Thanks