Convert loop index number to text month
I have an excel file, stored in a Template folder, which I want to copy to multiple sub folders. There are 12 sub folders (one per month). These sub folders are formatted as MM MMM e.g. 01 Jan
Rather than using 12 individual Copy Files actions, and manually writing out 01 Jan, 02 Feb per each file location, I thought it would be quite simple to create a for loop from 1 to 12 and convert the loop index each time to "00" & MMM. and then concatenate that to a string to form the file path. I can then run a single copy file action within the loop.
So, my question is, how do you convert a number to display formatted as a month?
Try using Get Subfolders in Folder, then loop through the results with a Copy File.