Checking If a Workbook is Open Using VBA and Executing from R

Introduction
In the world of data analysis and automation, Excel and R are powerful tools that can work in tandem to streamline workflows. One common task is to check if a specific Excel workbook is open. This can be done using VBA (Visual Basi…