check file isn't open

  1. S

    Check if target workbook is already opened before start copying data between two workbooks

    Hi everyone, So I have a macro which copies certain data to an other workbook. It works fine but I have this issue that every time the macro begins to run (somebody is migrating data to the main excel file) it should be checked first if the main file was opened/is open by someone else on the...
  2. T

    Code to check if file ISN'T Open out of all open workbooks

    Hi there I have code to loop through all open workbooks to see if a file is open. I've been using this code for years and it works great. The target file changes it's name every month, so we use look for a constant word in the file name to locate it. NOW, however, if the file ISN'T found within...

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