Determine if Excel workbook is already open
How do I determine if an Excel workbook is already open? Any help would be appreciated - thanks. I have tried the two methods below. Test1 fails if the workbook is not open because it can't...
Forum Discussion
I need to find out whether a particular excel file is opened or not.
I tried Michael's code,
Test1 gives error even if the workbook is open, vb run time error - subscript out of range.
I also tried with Irina's Code, the count variable is set to zero even if there are some excel workbooks opened.
Where am going wrong in the code?
I tried Michael's code,
Test1 gives error even if the workbook is open, vb run time error - subscript out of range.
I also tried with Irina's Code, the count variable is set to zero even if there are some excel workbooks opened.
Where am going wrong in the code?