We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub List_Files() 'List Files from a given directory in Column A of current excel worksheet Dim MyFolder As String Dim MyFile As String Dim a As Integer MyFolder = "C:\Test\" ' <-- Change to your folder MyFile = Dir(MyFolder & "*.*") a = 0 Do While MyFile <> "" a = a + 1 Cells(a, 1).Value = MyFile MyFile = Dir Loop MsgBox "Done." End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need help with an Excel Formula||2||29|
|incrementing rows containing a string and number by 1 in excel.||3||25|
|Need Excel Formula for extract out date only||17||38|
|VBA to Update status Column based on recent date||20||41|