(Microsoft Excel VBA) Check to see if A workbook is Already Open and Close the Open Workbook

Описание: This video shows you how to solve the issue where you are running VBA code and you need to make sure a workbook that you are calling is closed before you run code. I ran into this issue when I would work within a workbook and automation referring the workbook would fail or work incorrectly since the file was intended to be read-write vs. read-only.

I've added the 2 workbook examples in the link below for you to study and use. I do not own rights to this code but I've modified it to my needs.

The examples are below:
https://www.nomorelinesla.com/wp-cont...

Insure your cell phone, TV, video game console, and much more with an AKKO protection plan. Click on the link below to learn more:
https://akko.pxf.io/Xxbd4X

If you are in the market for the newest version of Microsoft Office, you can purchase a lifetime membership from Stack Social for Windows of Mac from the link below:
https://www.stacksocial.com/sales/mic...