ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Stupid question (https://www.excelbanter.com/excel-programming/393294-stupid-question.html)

[email protected]

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


Tom Ogilvy

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

--
Regards,
Tom Ogilvy


" wrote:

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



JLGWhiz

Stupid question
 
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.

" wrote:

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



[email protected]

Stupid question
 
On Jul 13, 12:16 pm, JLGWhiz
wrote:
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.



" wrote:
Is text considered a string automatically by VBA? I imported a text
file and I'm wondering is that text automatically a string- Hide quoted text -


- 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



All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com