How to read excel file if it is already open in Microsoft Excel?

Jun 20, 2014 at 10:16 PM
I am able to read all excel files with the code you provided but I cant read them if they are already open in Microsoft Excel.
Is it possible?
Jun 23, 2014 at 10:46 AM
Yes, of course :)
Excel locks non-readonly files while modifying them.