Results 1 to 13 of 13

Reading in text file into array. Each element is a line of file. Why last element a space

Threaded View

  1. 01-14-2014, 10:32 AM #1
    welchs101
    welchs101 is offline
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Reading in text file into array. Each element is a line of file. Why last element a space

    Hi,

    i am providing macro and test input file. Note, please change ext of input file from .txt to .sat.

    If you run the macro and stop it just after reading in the file then yo uwill see that the last entry in array A(16) is a space .........why? and how to prevfent this?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Stat table with formulas for each data element but only when the element exists in table
    By stevemills04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2013, 05:50 AM
  2. STart reading text file at line 2
    By Striker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2006, 08:35 AM
  3. Reading a text file line by line-How do I open the text file with VBA
    By stressman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2005, 12:29 AM
  4. read data element from XML file
    By Steve Moreno in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2005, 06:05 PM
  5. Reading a text file line by line
    By Foss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1