Extract file contents to excel

[crgk1971]

I have large number of sql files in various folders in my windows7 laptop.
I have extracted the file names with full path in column A in an excel work book.
For each row, I now need to parse the file and extract the file contents and put it in column B, for the respective row.
I want the entire query content to be populated in the row without parts of query to spillover to other column (based on comma etc in the query)
I am using excel 2007
Appreciate your help

 

[wigi]

For instance:

Sub wigi()

    For Each r In Columns(1).SpecialCells(2, 2)
        Open r.Text For Input As #1
        r.Offset(, 1).Value = Input(LOF(1), #1)
        Close #1
    Next

End Sub

 

[crgk1971]

Thank you
Works like charm

 

[wigi]

You're welcome !