How copy final xlsx to other directory

Hi everyone, I need help.
I try to copy the final result of the workflow (xlsx) saved in "C:\user", to another directory ("d:\results").
I try to use "Run Command", but my user does not have an administrator access and does not work with ".bat" files.
Is there any option or component to make the copy at the end of my workflow?
Thank you all.

Anderson Prospero

Workflow

Accepted answers

a-prospero

Amazing. I solved the problem using the R component including the commands:

flist <- list.files ("C: / Development /", "^ archive.xlsm $", full.names = TRUE)
file.copy (flist, "Y: / SIAN /")

I include the Block Component to condition the execution of the R after the end of execution

Thanks for everyone.

\0/

All comments

estherb47

Hi @a-prospero

You can set up the Output Data tool to write an excel file to anywhere that you have access. And you can have multiple Output Data tools writing multiple files at the same time.

Hope that helps!

Cheers,

Esther

a-prospero

EstherB47.

I have a "workflow" that saves several times, in several "sheets" of an output file xlsx. My need is to save this xlsx file at the end of execution in a network directory, for performance reasons. So, at the end of the execution I want the file saved in "C: \ user" to be copied whole to "D: \ results".
I tried to use the "Run Command" but I can not execute ".bat" files.
Now with more details maybe it will be easier to help me, lol.

Thanks a lot.

AProspero

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703