You’re not using the correct activities.
I think what you’re missing is that CurrentFile is not a string. It’s a FileInfo variable so you have to use CurrentFile.FullName to get the path and filename.
In your write range activity, you’re selecting a specific file there. I am doing this for multiple files in the for each file activity, maybe im misinterpreting.
Also, your example I don’t see excel scope.
I only gave you an example showing which activities to use, and how to get the path and filename from CurrentFile. The rest of it - configuring your file paths, filenames etc - is up to you.
You don’t use Excel Scope for the Read Range Workbook and Write Range Workbook activities. You use Excel Scope for the Excel Read/Write Range activities.
I recommend doing this training so you’ll have a better handle on automating with Excel.
There’s tons of other free training there that will give you a good foundation.
Ok-I emulated exactly what you had, but the write range I tired to write back to CurrentFile.FullName I guess does not work. Illl go back through that training
Holy cow, I found the issue. I have three files and one of them DOES NOT have the column name. I removed that file and it ran perfectly. I need my users to have consistent columns. I will consider this solved.
Thank you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.