Page 1 of 1
Check who has file open
Posted: Fri Sep 04, 2020 9:54 am
by Rukbunker
Hey Oleg,
Is it possible somehow to see which user (file lock) has opened the file and returning that value to a variable? I'm using now the
{IsFileFree(c:\autoexec.bat)} method. It returns a true or false but for the error handling, I would like to include who is the one to blame
Re: Check who has file open
Posted: Mon Oct 05, 2020 7:57 pm
by juanlu
Agree.
And additionally, the ability to unlock the file (close the file, or kill the process, etc.):
https://robotask.com/forum/viewtopic.php?f=2&t=2751
Re: Check who has file open
Posted: Wed Jan 15, 2025 8:32 am
by sarnusch
Good morning,
I would like to make this topic current again.
I have to update an excel file every day but if someone has already opend it the update fails.
It would be great if I could identify the person who has opened the file to inform them that the update has failed because the file is still open.
Re: Check who has file open
Posted: Thu Jan 16, 2025 5:51 pm
by felipe
When feeding data into a spreadsheet, I take a different approach. First, I create a data source, which can be a TXT, CSV, or even an Excel file. The target spreadsheet retrieves the data using Power Query, making the process efficient and streamlined.