Issues If You Don't Handle Contention When Opening Workbooks In VBA

If your macro needs to open an external workbook to import or export data, you may encounter file contention in a multiuser environment. In this video (Part 1), I show a standard approach to opening workbooks and put it to test against different scenarios of contention. How will it fair? Watch NEXT    • How To Handle Contention When Opening Work...   In Part 2, I share my method of handling contention explicitly dealing with the same scenarios. Excel Version Recorded using Excel Pro Plus 2021 but also works with Microsoft 365 You cannot run VBA/Macros directly in Excel online Excel Tips Playlist    • EXCEL / VBA TIPS