ofile

  1. NessPJ

    [VBA] Check files and filedates within folder and list them

    Hey guys, I would like to create a simple tool in Excel that can list a few files in the specified folder together with the modified date in Excel. Now i have 2 pieces of code that should do this, but i noticed that their approach seems different. The first one will not work for me (it gives...
  2. R

    Code Help For Adding Or Replacing Sheets

    Earlier this week I asked for a code to add a sheet to multiple workbooks. This works fine but now I learned I need to replace the sheet already with an updated one. Is there away to edit this to replace the sheet or remove the sheet and I can run the original code again? Public Sub...
  3. S

    Deleting Source .CSV file after embedding it to worksheet via VBA

    Hi…I’m trying to embed a .csv file to an excel sheet and then delete the source file using Windows 10 and Excel 2016. My code embeds the sourcefile to the worksheet ok but when it tries to delete the original .csv file I get a “Run-time error ’70’: Permission denied message. I’ve tried the same...
  4. V

    Ignore "Closed" Folders

    Hello All I am hoping someone can help on this please One of our members kindly gave me this code which works great The only issue is I want to ignore any folders that have "Closed" as the name in any folder but I don't know how to change the code [Public Sub ScanSubfolders() Dim FileSystem...

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