Text File - read Size using RRS feed

  • Question

  • I have VBA Code (Thanks to this community) that uses file picker to get my files. This code will pull the data into the spreadsheet one file at a time. I now have a problem that the data is not the same for each text file. The keys to have the same data is the file size. What i would like to do is either have a fixed header and add the record in to the correct column which would mean checking the hearder info of the selected file to know which column to insert the records dataset. OR pull in like file sizes to a seperate TAB.

    Following is the portion of the code i use;

    Jim Neely

    Wednesday, June 26, 2013 7:17 AM