I am trying to download an xlsx attachment from incoming mail and save it to a dynamic folder. Until this part everything works well. However, when i want the robot to read cell from the downloaded cell it says the workbook does not exist.
Please see below the codesi use:
For Save Attachments Folder Path is as follows → “Attachments/” +emailMessages+“/”+formattedStamp.ToString(“dd-MM-yyyy_HH-mm-ss”)+“/”
Step 2- I assign “files” variable (list of strings)
This must be the issue
As the seconds and minutes might change while being in save attachment and while calling with GetFiles method
So let’s do one thing
Before using the folder and string concatenation in the save attachment assign this to a variable
In_folder = “Attachments/” +emailMessages+“/”+formattedStamp.ToString(“dd-MM-yyyy_HH-mm-ss”)+“/”
— now use this variable In_folder in the save attachment and in GetFiles as well like this files = Dircetory.GetFiles(In_folder)
Simple isn’t it
Hope this would help you
Thank you @Palaniyappan, i tried but the issue still continues. I think the problem is related with the workbook path that i must write for read cell activity. Do you think “folder” variable here is correct?