file list

  1. C

    Display Last Modified Date for List of File Names

    I have the following code which, when called, will display the folder contents as a list on a dashboard in Excel: Sub DisplayInProgressBeth() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Range("S29:S38").Select Selection.ClearContents 'Create an...
  2. J

    Create list of files within folder (and details), archive previous list

    Hello, I am having some issues with a command I am trying to do. My goal is to have a worksheet saved in my folder C:\Users\1234\Desktop\Data .... with a macro button that does the following: Copy/paste values of cells C2:E & "last row in column e" into column H2:K & "last row in column e"...
  3. C

    Use Excel 2007 to create a File Location and List

    Hi, I have the below macro that will look in a specific File location / directory and produce me a list of files within that area. If possible i would like to change the macro so that rather then me going into the VBA to change the location an input message box asks me which file location i...

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