At the risk of sounding like a rookie, which I am in regards to VBA,
where within what I have would this need to be placed in order for it
to proccess the proper file. Also, you stated that I need to have the
full paths as in your example. The files do not always have a suffix
on them. If I write
Can anyone show me how to import the first 2 rows of data from the
text file into excel as the following code builds the list?
Thank You for ANY help..
John
On Sep 16, 2:04 pm, johnofeasttex j...@demco-mfg.com wrote:
I searched around and found some code that allows me to create a list
of the
hi John
can you attach the notepad file and output excel file
On Mon, Sep 19, 2011 at 6:40 PM, johnofeasttex j...@demco-mfg.com wrote:
Can anyone show me how to import the first 2 rows of data from the
text file into excel as the following code builds the list?
Thank You for ANY help..
Hi John
Try this one
you need to have full paths in column f Like below
C:\Documents and Settings\achamanlalko\My Documents\Downloads\3004.OUT.txt
C:\Documents and Settings\achamanlalko\My Documents\Downloads\7110.txt
Sub importnotepaddata()
Dim i, j As Long
Dim s As String
Set objFSO =
After digging around a bit, I found the following code that seems to
work fine for getting the file list from a particular directory. I
just need to figure out how to pull the data from the comment line in
the file. any suggestions?
Thanks
John
On Sep 15, 2:48 pm, johnofeasttex
I searched around and found some code that allows me to create a list
of the files in a given directory. I just need to figure out how to
pull the comment data from the file.. any suggestions? What I have
so far looks like this:
Option Explicit
Sub GetFileList()
Dim strFolder As String
Dim
Hello,
I need to look in individual directories of text files and create a
list in Excel showing all files in that directory in one column with
data from the first row starting with the letter N parsed into the
adjacent 2 columns. The data will be of various lengths but the format
will look like
Hi Noorain,
The following are two examples of the text files that would be
encountered. I have only shown the first and last 4 rows of the files.
The over all length of the files is very variable but hold to the same
format. Some files may end in *.out, *.txt or just *.. The files
should all