Hi Ashish,
You are the man!!! This works great! After I had a backup get posted to the
wrong location while updating a computer in the shop, our operators suddenly
started complaining that thier tables were wrong that they had been manually
updating each time they saved thier work. This will
, Len(s) - InStr(s, ()), Len(Right(s,
Len(s) - InStr(s, ())) - 1)
Cells(j, 7).Value = Left(s, InStr(s, () - 1)
Exit Do
End If
End If
Loop
objFile.Close
Next j
Set objFSO = Nothing
End Sub
Regards
Ashish koul
2011/9/19 johnofeasttex j...@demco-mfg.com
OK
The file Book3 has
I also wanted to add that when I scan the contents of the directory that has
been updated, I see that the .txt has been added to the file name. This is
not a problem initialy, but as files are added to the directory and the
macro is run again, it adds another .txt to the end of the files it
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
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 j...@demco
= Nothing
End Sub
This I can modify for my purpose and appears to work good.
Thanks
John
On Sep 15, 2:48 pm, johnofeasttex j...@demco-mfg.com wrote:
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
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
CAMDEN
The ID is always after the letter O.
The comment is always between the perentheses.
Thanks for looking at it.
John
On Sep 15, 12:52 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear John,
Please share sample sheet with us
On Thu, Sep 15, 2011 at 9:39 PM, johnofeasttex j