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 t
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 = Cre
hi John
can you attach the notepad file and output "excel file"
On Mon, Sep 19, 2011 at 6:40 PM, johnofeasttex 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..
>
> John
>
> On S
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 wrote:
> I searched around and found some code that allows me to create a list
> of the files in a given
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 va
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 wrote:
> Hi N
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 begin
Dear John,
Please share sample sheet with us
On Thu, Sep 15, 2011 at 9:39 PM, johnofeasttex wrote:
> 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 le
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
