Hi all
Has anyone written a code stage that can check to see if an Excel workbook is open with another user within the business
We have recently received input files from within the business which they have left open in error and caused us to be unable to move the file from the folder once loaded into the queue
I was thinking if we could run a code stage which checks first if the file is already open it can output a flag to identify this and then if it is already open we will not attempt to load the file
Thanks
Has anyone written a code stage that can check to see if an Excel workbook is open with another user within the business
We have recently received input files from within the business which they have left open in error and caused us to be unable to move the file from the folder once loaded into the queue
I was thinking if we could run a code stage which checks first if the file is already open it can output a flag to identify this and then if it is already open we will not attempt to load the file
Thanks