Print all excel files in a folder

[ChienTrinh]

Hi everyone,

How can I print all excel files in a folder? Action "Print document" requires exactly link to an excel file

Thanks for your support.

[DamoBird365]

Hi @ChienTrinh 

Could you use cmd prompt?  If you run dir /b *.xlsx from your folder you can get the file names.  Drop the first few rows and then iterate through the next lot to print off your files?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[ChienTrinh]

@DamoBird365  Thanks for your help. I have run with CMD and could get the all xlsx files in my folder. but what should I do for the next steps with print action from 5th line in the picture? I'm a newbie. ^^

[abdndamo · Accepted solution]

Hi @ChienTrinh 

I am replying on behalf of myself @DamoBird365 as I am currently locked out.

I have probably just made it a bit more complicated for you - sorry.  I have just realised that you can use the get files in folder step and then a for each item in the list.

Hopefully this helps and the real me can return tomorrow 🙂

Cheers

Damien

[ChienTrinh]

That's great, 

Thank you so much!!!

[NercyCrab]

Let's say we are printing the files via the above loop, this time to PDF printer.  2 issues appear:

1. we have to manually enter the filename for each output file

2. multiple windows will open up at the same time 

How can we automatically assign the filenames for the output files?

[DamoBird365]

@NercyCrab for pdf I am assuming that an adobe confirmation box loads up?  You woud need to grab the UI elements for the app windows and insert a wait until element is visible and then select the button to print.