Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Copying a template file

sbackhouse
6 - Meteoroid

Hi Alteryx Community

 

As a newbie to Alteryx I was hoping for some help with a basic query. I have seen similar posts already but none seem to quite work for me!

 

Its a simple one hopefully so here goes...

 

I want to take a file saved in my desktop (it is a macro enabled excel file with a .xlsm extension and I want to create 20 copies of the same file with 1,2,3 etc at the end of the filename.

 

It is important to preserve the .xlsm as once I have pushed data out to each separate file I want to be able to open them and then run the macros.

 

Many thanks in advance.

 

Steve

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@sbackhouse 
Just as you have tagged, we can use a run Command tool to do this.
A quick sample is 0630-sbackhouse.PNGas  below.

 

messi007
15 - Aurora
15 - Aurora

@sbackhouse,

 

You can do that using Blob tools :

 

Please see below :

 

messi007_0-1656576460351.png

 

 

Attached the workflow,

Regards,

Qiu
21 - Polaris
21 - Polaris

@messi007 
It seems that I am a bit out of date.
The blob tool seems better.

sbackhouse
6 - Meteoroid

Many thanks, worked well!! Thanks for such quick responses.

messi007
15 - Aurora
15 - Aurora

@sbackhouse,

 

Could you please my answer as a solution :) It will help others.

 

Happy to help,

 

Regards,

Prime Analytics loves Alteryx.png

Labels