storename

  1. T

    Macro to tell me which of a list of files is read only?

    Hi Everyone, I have a sheet called "Read Only" in it I have a list of 50 files Column B5:B55 what I'd like is a macro to go to each file and test if it opens and if its read only add next to its name in Column C "Read Only" so i can see which files are not closes for editing. all documents...
  2. T

    Macro to check if a Workbook is read only?

    Hi Everyone, I have the following macro that opens up a document and runs another macro, I use it to update a document that lots of people share by creating the changes I want in a macro then running this code and the document is updated without having to hold everyone up. this all works fine...
  3. T

    Can I fix this macro to run on all of my folders not just 1?

    Hi Everyone Sub OpenLon() StoreName = "Londonf" On Error Resume Next Kill "S:\" & StoreName & "\New Documents Folder\*.TMP" On Error GoTo 0 End Sub The above code works great for removing TMP files from "New Document Folder" Is there a way I could get it to run on all folders in "S:"...

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