I am trying to to move a file from one folder to another. I save the attachment from an email to a folder. The file is an .xlsx (and the only file in that folder) and the name of the file has a date on it that changes each time.
After saving the attachment, i use an assign to get the file with directory.getfiles(“my path”,“*.xlsx”)
I then do a For Each with the input being the list created by the assign to loop through to get the file. I put a move file in the for each but it doesn’t move the file. I’m not sure where I am going wrong or what to do differently to get it to move into a different folder.