I’m using Read Range (workbook version) to read several Excel files. I only need to read information from these files (no write, rename, or move activities), but occasionally I receive the “File In Use” error when another user has the file open. So is there a way to read the information within an Excel file even when it’s open by another user?
Well the Excel gets locked out when someone has it open. That is a normal behavior. If I recall correctly the Workbook version of Excel is used so that you don’t have to have Excel installed on the host machine.