Help with filtering out data rows with certain values in columns

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.