<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Not sure if this is what youâ€¦ in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50154#M5427</link>
    <description>Not sure if this is what you're looking for or not, but I always have the process check for a lock file before opening Word documents, Excel workbooks, etc. Just as you mentioned there is a second file with the same name but begins with ~$.
I usually first do File Exists for the [Folder Path] &amp;amp; [File name]
...followed by a decision stage to determine whether to throw an error if the file does not exist.
...followed by File Exists again but this time forÂ&amp;nbsp;[Folder Path] &amp;amp; "~$" &amp;amp; [File name]
...followed by a decision stage to determine whether to throw an error if the lock file exists, indicating that someone else has the file open. This may not be perfect, but it has never failed for me.
Â&amp;nbsp;
The other option (which I have not attempted because I don't prefer it) is to create a copy of the file before opening it. You'd check to see if the file is there and then check to see if there is a lock file for it as well. If there is a lock file, then you copy the file into the same folder with a new name. Then open the new file, get the data, and do whatever you need to. Then either archive or delete the new file afterward. The problem with this method is that it doesn't work if you need to write data inside the file. It would really only be useful if you're only reading from the file.</description>
    <pubDate>Fri, 10 May 2019 18:32:00 GMT</pubDate>
    <dc:creator>david.l.morris</dc:creator>
    <dc:date>2019-05-10T18:32:00Z</dc:date>
    <item>
      <title>Handling of "File In Use" Message in Word</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50153#M5426</link>
      <description>Hello Blue Prism Community

I have one Process Automation, which have to open an Word Document to gather information from the Word Document. Unfortunately, some of the business users forgot to close their Documents after they provide the documents to the Robot. The Robot stops his work, because he isn't able to handle the "File In Use" Message in Word (attach).

Could someone give me an advice how I can handle this Message box/Problem? Furthermore, if the Document is in use by someone,Â&amp;nbsp;BP add the document twice to the Workqueue. First Item with the correct title e.g "TESTDocument.doc" and the second as "~$STDocument.doc".

I want to have that the Robot ignoreÂ&amp;nbsp;suchÂ&amp;nbsp;as documents. I am working know on BPv6.4 and Windows 10.Â&amp;nbsp;Â&amp;nbsp;

Thanks in advance for you support and feedback.

BR

Andre</description>
      <pubDate>Fri, 10 May 2019 17:36:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50153#M5426</guid>
      <dc:creator>AndreKöpplin</dc:creator>
      <dc:date>2019-05-10T17:36:00Z</dc:date>
    </item>
    <item>
      <title>Not sure if this is what youâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50154#M5427</link>
      <description>Not sure if this is what you're looking for or not, but I always have the process check for a lock file before opening Word documents, Excel workbooks, etc. Just as you mentioned there is a second file with the same name but begins with ~$.
I usually first do File Exists for the [Folder Path] &amp;amp; [File name]
...followed by a decision stage to determine whether to throw an error if the file does not exist.
...followed by File Exists again but this time forÂ&amp;nbsp;[Folder Path] &amp;amp; "~$" &amp;amp; [File name]
...followed by a decision stage to determine whether to throw an error if the lock file exists, indicating that someone else has the file open. This may not be perfect, but it has never failed for me.
Â&amp;nbsp;
The other option (which I have not attempted because I don't prefer it) is to create a copy of the file before opening it. You'd check to see if the file is there and then check to see if there is a lock file for it as well. If there is a lock file, then you copy the file into the same folder with a new name. Then open the new file, get the data, and do whatever you need to. Then either archive or delete the new file afterward. The problem with this method is that it doesn't work if you need to write data inside the file. It would really only be useful if you're only reading from the file.</description>
      <pubDate>Fri, 10 May 2019 18:32:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50154#M5427</guid>
      <dc:creator>david.l.morris</dc:creator>
      <dc:date>2019-05-10T18:32:00Z</dc:date>
    </item>
    <item>
      <title>Hello David
Thanks a lot forâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50155#M5428</link>
      <description>Hello David
Thanks a lot for your support.
I was able to find with your tip a solution for my Problem.
Best regards
Andre</description>
      <pubDate>Fri, 10 May 2019 19:01:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50155#M5428</guid>
      <dc:creator>AndreKöpplin</dc:creator>
      <dc:date>2019-05-10T19:01:00Z</dc:date>
    </item>
    <item>
      <title>You can also open file readâ€¦</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50156#M5429</link>
      <description>You can also open file read onlyÂ&amp;nbsp;if you are not changing it in any way and supress possible alerts temporarily.</description>
      <pubDate>Mon, 13 May 2019 12:18:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Handling-of-quot-File-In-Use-quot-Message-in-Word/m-p/50156#M5429</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2019-05-13T12:18:00Z</dc:date>
    </item>
  </channel>
</rss>

