Updating cells from an external file

[bromberg]

How can I update cells in EXCEL from an external file containing data that I just downloaded into a text file. For example, I want record 1 of my file to update the contents of cell A30, record 2 of the file to update cell B30, etc...

 

[Bruno_x]

Hi Danny,
Welcome to the board !

Sub Update()
f = FreeFile
ColNr = 1
Open "c:\data\test.txt" For Input As #1
Do While Not EOF(f)
    Line Input #f, t
    Cells(30, ColNr) = t
    ColNr = ColNr + 1
Loop
Close #f
End Sub

Where "c:\data\test.txt" is the file with your data...

 

[Rusty]

Cool