Hello, I am trying to open an Excel file, read in the rows and move a file from one column to the destination in another column. My problem is that a portion of the file name will change daily. And you can not read in a wildcard into the copy function, or I get an illegal character error. This is what I have so far:
And this is the .csv that I am using:
How else can I get this to work without using a wildcard?