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

Jun 20, 2014 at 9:16 PM
Hello,
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?
Thanks,
Jun 23, 2014 at 9:46 AM
Yes, of course :)
Excel locks non-readonly files while modifying them.