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
Check whether u have mentioned correct workbook name with proper extension ( *.xls or ".xlsx)
MyWorkbookName = "myworkbook.xls"