Contributions
Re: Determine if Excel workbook is already open
I need to find out whether a particular excel file is opened or not. I triedMichael's code, Test1 gives error even if the workbook is open, vb run time error - subscript out of range. I also tried withIrina's Code, the count variable is set to zero even if there are some excel workbooks opened. Where am going wrong in the code?5.8KViews0likes0Comments