Forum Discussion
keerthana_annau
11 years agoNew Contributor
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?
Related Content
- 12 years agokirk_bottomley
- 3 years agoLarry_M
Recent Discussions
- 4 hours agoashly