Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 67
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 67
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
big stupid question Wu Excel Discussion (Misc queries) 4 May 17th 08 05:33 PM
Stupid Question Justin Kreamer Excel Discussion (Misc queries) 1 May 2nd 08 07:47 AM
Probably a Stupid Question Paige Excel Discussion (Misc queries) 10 February 4th 08 06:52 PM
Stupid Question mastermind Excel Worksheet Functions 1 August 5th 06 07:03 PM
Stupid, stupid question.... DS Excel Programming 3 September 25th 05 03:51 PM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"