List files in A1 Cell Downwards??

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

OK can you hlp me with this part?

Sub ListFiles()
F = Dir("C:\*.XLS")
Do While Len(F) > 0
ActiveCell.Formula = F
ActiveCell.Offset(1, 0).Select
F = Dir()
Loop
End Sub

I want it to post the file names from A1 onwards. At the moment, i
just posts them in any ActiveCel
 
Back
Top