isworkbookopen

  1. J

    VBA Check if Excel workbook located on shared drive is locked by another user

    Hallo, I am trying to check if the file is locked by another user. File is located online : "https://my.sharepoint.com/personal/jhofmann/documets/ForecastEurope.xlsx" I checked with code like this Function isworkBookOpen( Filenam as string) Dim ff as long, errno as string On error resume next...
  2. J

    Check to see if Workbook is already open

    I have been all over the internet for this one and I can't get my VBA to recognize the codes that are out there, ;like .IsOpen, IsWorkbookOpen("???")= true/false, and various other combination of code to achieve the result. Some information on what I am trying to achieve I am trying to make...

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