extract filenames

  1. I

    Extract file names with extensions and absolute path with VBA code

    Hi all, I am trying to create a macro in excel for extract file names (with extension) and their absolute path, from one main path (always a local path), but I am afraid I am not able to. My idea is to insert in cell C2 the main path, where there are files, folders and subfolders (with files...
  2. J

    Extract file details from folder and subfolders - VBA

    Hi everyone - I found this great code below that extracts the file names for all files in my folder. I was wondering if anyone knows how to also add the: "file path"; "file size"; "last modified date"; and "last modified by". Please let me know if you have any thoughts! Sub Auto_Open()...
  3. A

    How to extract filenames from multiple zip/compressed folders

    I have folder named as "Task" which contains 10+ zip folders and each zip folder contain minimum 20 files. Now, in an excel I want to extract all the filenames in column A and their respective zip folder name in column B Can someone help with macro/VBA which can be used to obtain this data

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top