How do I get all files from a folder in Excel?

I have created a macro in excel and I am calling the macro at the beginning of the day by putting this command in the start button.

(Sub Macro()). This will look in the folder that I have saved it in which contains thousands of .xls files that the macro grabs them and saves them to my c:. The macro works just fine but it takes a long time when it is done. I only need the .xls files but everything is very tedious with the way it goes through all the .xls files and opens them. How do I change this? For example, it would be great if I could have a button next to the other macros and say that when you click that button it grabs all the .xls files that is under c:macro.

In macro code below I would type in what I want in the code in front of. "C:macro". Is there a code that grabs the data right before that instead of typing it in front? so it can grab the data from c:? ActiveWorkbook.SaveCopyAs Filename:="c:Users amedesktopmacro.xls" Thanks and hope to hear from you soon. Use the following function to save all files: Function BackupWorkbooks(). Dim filePath As String. filePath = "c:Users. Dim x As Variant, Path As String. Path = filePath. With Application.FileDialog(msoFileDialogFilePicker) .InitialFileName = Dir(Path & "*Show If .SelectedItems.Count <> 0 Then
For Each x In .SelectedItems Debug.Print Path & x ActiveWorkbook.

How to get a list of all files in a folder and subfolders in Excel?

Assuming you are using a version of Excel that has the Data -> Get External Data.

This will add a new sheet to the workbook. You must have at least one sheet in the workbook.

In the new sheet that is now opened, add a named range called "Table", and use it as your data source. In the Data Connection dialog window, select Use a file (*csv) from a network path, then navigate to the folder/folder in which you want to find the files.

Press OK. Note, the data source will automatically update as files are added and removed from the folder. This method should work just fine in Excel 2025 or Excel 2025 as well (though some dialog boxes would be slightly different). If it doesn't work, please post a more complete question including the steps you tried and any error messages you received.

Here is a little macro that will loop though all files in a given path. Works perfectly on my workbook, but be warned I am still developing it so if anything goes wrong its on me.

Sub Test(). Dim oFiles As Object. Set oFiles = CreateObject("Scripting.Dictionary") '~~> Clear all objects - just for test. For Each obj In oFiles. Obj.clear Next. Set objShell = CreateObject("Shell.Application") For Each objShell in objShell.Namespace(MyDocuments).Items
Set fname = objShell.GetDetailsOf(objShell.getName)
OFiles(objShell.Name) = GetFilesinFolder(objShell.Path & "" & fname & "", True, -1)
End Sub. Function GetFilesinFolder(path As String, forceUpdate As Boolean, Optional nmax As Integer) As Object. Dim objShell, objFolder, objFldr, varItems, i, count2 As Integer. Count = 0. Count2 = 0. Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.Namespace(path).ParseName(path)

Is there a way to get a list of all files in a folder?

I have a directory that has subdirectories in it.

Each of the subdirectories has files in it. What I want to do is write a script that will give me a list of all the files and what directory they are in.

I want it to be generic so that if I have a folder called 'test', and the files are in folders called 'test1' and 'test2', the script should give me output of the files like: file.txt test1 file.txt test2 To get a list of all files within a directory, I would use something like this: for root, dirs, files in os.walk(yourdirectory): for name in files: print os.path.join(root, name)
The os.walk() function will walk through your directory, returning information about every file in each sub-folder that it finds. The loop over names prints the name of each file (the name of the directory doesn't matter), which is then joined with the root directory to get the full path to that file.

You can do a recursive loop over the directory listing (on Linux, this is usually done by just typing "ls -l" without any arguments). Something like this will work on most Unix systems (this is C, but it should be easy to convert to Python): #!/directorylist./test1 ./test2 ./test3