In VBA, I opened an MS Excel file named 'myWork.XL' programmatically.
Now I would like a code that can tell me about its status - whether it is open or not. I.e. something like
IsWorkBookOpened('myWork.XL)
?The file “ file name” is checked out or locked for editing even though no one has it open. You might want to try: From the document library Settings Document Library settings Manage checked out files. Solution: Proceed to the library where the document was being held. Checked out a different document in the same folder. Then, checked-out the presentation we were having issues with. The system recognized both as being checked out to me. Then, I checked them both back in. Problem solved.
Andrei Konstantinov3,61611 gold badge2222 silver badges4545 bronze badges
user1222679user1222679
closed as too broad by brettdj, rene, TylerH, NicE, AstroCBMar 9 '15 at 0:06
![Mac endnote this library is currently being used by someone else Mac endnote this library is currently being used by someone else](/uploads/1/2/4/8/124888000/778625266.png)
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
7 Answers
Tim Cooper124k3232 gold badges252252 silver badges233233 bronze badges
Siddharth RoutSiddharth Rout119k1414 gold badges161161 silver badges212212 bronze badges
For my applications, I generally want to work with a workbook rather than just determine if it's open. For that case, I prefer to skip the Boolean function and just return the workbook.
Dick KusleikaDick Kusleika28.4k33 gold badges4040 silver badges6363 bronze badges
If its open it will be in the Workbooks collection:
Charles WilliamsCharles Williams20.3k55 gold badges3030 silver badges3737 bronze badges
I would go with this:
as sFileName you have to provide direct path to the file for example:
user2267971user226797124311 gold badge44 silver badges1111 bronze badges
What if you want to check without creating another Excel instance?
For example, I have a Word macro (which is run repeatedly) that needs to extract data from an Excel spreadsheet. If the spreadsheet is already open in an existing Excel instance, I would prefer not to create a new instance.
I found a great answer here that I built on:http://www.dbforums.com/microsoft-access/1022678-how-check-wether-excel-workbook-already-open-not-search-value.html
Thanks to MikeTheBike and kirankarnati
Derek JohnsonDerek Johnson
BulkiBulki53011 gold badge77 silver badges2727 bronze badges
Kannan SureshKannan Suresh4,00633 gold badges2828 silver badges5656 bronze badges
Not the answer you're looking for? Browse other questions tagged excelvba or ask your own question.
Before you begin, make sure to back up your iMovie libraries, your media, and the iMovie app.
Try these troubleshooting steps in order
After trying each step below, test iMovie again to see if you've fixed your issue.
Restart your Mac
Reset NVRAM
If you use an external device with iMovie like a camera, reset NVRAM:
- Shut down your Mac.
- Disconnect all external devices other than your keyboard and your mouse.
- Reset NVRAM.
- Open iMovie and attempt to reproduce your issue.
- If iMovie works, reconnect devices one at a time until you can reproduce your issue. Restart your Mac after reconnecting a device if the device requires it.
- If iMovie still doesn't work, you might need to update your device's firmware or have the device serviced.
Update macOS and iMovie
Choose Apple menu () > App Store, then click Updates. If an iMovie update is available, click Update to download and install it.
Check camera and media format compatibility
Make sure you're using a camera and media format that works with iMovie. If you can't find your camera listed or need further assistance, contact the manufacturer of the device for support.
If you're using a third-party video interface with your Mac, check with the manufacturer for firmware or other software updates for your device.
Test with a new library and project
You can create a new library and test project to check if the issue is with your library, project, or iMovie app. First, create a new library:
- Quit iMovie.
- While you press and hold the Option key, click the iMovie app in the Dock or double-click the iMovie app in the Applications folder.
- In the Open Library window, click New to create a new library.
- Name the test library 'Test iMovie Library,' then save it to the Desktop.
Next, create the test project using a built-in trailer template, then export it as a QuickTime video file:
- In iMovie, click Projects to return to the Projects view.
- Choose File > New Trailer, click the Action trailer template, then click Create.
- Choose File > Share > File, click Next, name the file 'Finish Line,' then save the video file to the Desktop.
Next, import the QuickTime video file into a new project in the new library:
- Click projects to return to the Projects view. In the window, click OK.
- Choose File > New Movie.
- Choose File > Import Media, then click Desktop in the Import window sidebar. Select the 'Finish Line.mov' file in the list, then click the Import Selected button.
- Select the clip in the browser, then press the E key to add the clip to the timeline.
- Try to recreate the issue you were having. For example, if iMovie quit when adding a transition, try to add a transition to the timeline.
If the new library and project work as expected, you've isolated the cause of your issue to the original library or project. Try to restore a previous version of the original library from a Time Machine or other backup.
Test iMovie with a new user account
Create another user account on your Mac, then test iMovie with the new user account.
Reset iMovie
Reset iMovie to default settings. Libraries won't be affected.
Reinstall iMovie
Delete iMovie, then redownload and reinstall it. Libraries won't be affected.