Making changes to each file within a list

[ltensmeyer]

So, I've been trying to figure this out for a bit now and was able to get some help in the form of an article on the directory tool, but I still feel very lost. So I have an excel sheet with a bunch of filenames in it (so I already have all the filenames) and i need to open each one, edit it, then save it as a new file. Do I need to make a macro to effectively do this? I don't want all the information from every file together, I want it to edit each file individually as well as save it individually. Help :(

[Qiu]

@ltensmeyer 
It sounds like that a batch macro might be suitable for the work.

But what would be the Edit work? is this Edit applicable to all your files?

[ltensmeyer]

@Qiu  Yes, so the files all have the same format and they all need the same changes made. 

[caltang]

What you’re saying is for example, you have 10 excel files stored in a folder and from that 10, you know what to rename each of them and you have the renames in a list? 

Then what you need may be the Run Command tool! https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamically-Rename-Output-File... 

[Qiu]

@ltensmeyer 
Would it be possible for you to provide a few dummy files and the changes required?

In that case, we can prepare a sample workflow maybe.