Copy and Paste Excel from one folder to another and add date

I have a method for you. Something I picked up from @AkimasaKajitani cant be thankful enough.

Workflow:

1. In blob input tool configure the template file.

2. In formula tool set the new filepath. This way we can generate filenames with date.

3. Configure the blob output tool to output the file to the location taking it from the field.

Try and let me know.

Hope this helps : )

copy and paste.yxmd

Luke_C

@atcodedog05 blob method is super simple, here is the other option using the run command tool. You just need to update the directory and some of the formulas to use your file paths:

Copy and Rename.yxmd

After you read the file as a blob you will still have the column from the directory input tool which will give you the filename of that specific file which you can use to create a new file.

Hope this helps : )

blob move.yxmd

All comments

I have a method for you. Something I picked up from @AkimasaKajitani cant be thankful enough.

Workflow:

1. In blob input tool configure the template file.

2. In formula tool set the new filepath. This way we can generate filenames with date.

3. Configure the blob output tool to output the file to the location taking it from the field.

Try and let me know.

Hope this helps : )

copy and paste.yxmd

Hi @atcodedog05

This looks super promising - only problem is when I try and download your canvas says "couldn't download - no file"

Try this @Wixard

copy and paste.yxmd

copy and paste - 2.yxmd

Luke_C

@atcodedog05 blob method is super simple, here is the other option using the run command tool. You just need to update the directory and some of the formulas to use your file paths:

Copy and Rename.yxmd

@atcodedog05

Absolutely brilliant! This is exactly what I was looking for!

Could I ask for one more thing, if its possible that is. Is there a way of just taking the original file name without having to hard code it directly in formula tool?

In other words, no matter what the file is called, it will just replicate what the file was originally called, and then stamp the date as per your solution.

Thanks a lot @Luke_C

Is it possible to use Wildcards in the Blob input tool?

For example Workbook*xlsx

I don't seem to be able to make it work

Thanks for the super quick reply. I'll give it a try!

Second question - is it possible to write to an output based on a wildcard?

In other words I am bringing in Workbook*.xlsx, but I want to write to a copy of this file which has the same name (the output is a copy of the input workbook in a different folder e.g. Workbook28Feb.

Reason is that I am writing to a range in order to maintain Excel formatting.