Utility - File Management - Get Files

[Anonymous]

When I use the subject object to get a list of files, it is capturing a temp file in the folder.  How do I stop this?  When the process runs, I'm getting the error "Excel cannot open the file '~$2018-04 44310000.xlsx' because the file format or file extension is not valid".  I am running the process for May, so it is opening April, updating, and saving as new month.  Many steps later (plenty of time for temp of 04 to go away), the file list is being retrieved with the utility.  When I do it manually, the temp file disappears immediately after the "save as" new month file.

[MetVonghiran]

Hello, kimlundquist There are 2 things that I think would be useful for you.  1) If no one else is operating in the same folder as your robot, try close all the excel first before you use the get files utility.     This should eliminate the risk of getting the temp files. 2) If the temp file was created because someone else is updating it, then you could add a decision stage to avoid opening file with ""~$"" in it or use loop to eliminate files name that have  ""~$"" in it first then use the file collection. I hope this work for you.   Regards, Met Vonghiran