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
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.
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.