Printing multiple Excel sheets in to seperate files

[Ayaanarjun-5885]

Hi, This is regarding Excel sheets. I have an excel file with 10 sheets i.e sheet 1 to sheet 10 . Now I wanted to print all the 10 sheets at a time with sheet names. Is that possible, if yes plz assist me

[OTrieger]

@Ayaanarjun-5885 
Can you be more precise what do you mean by print?

[Ayaanarjun-5885]

Hi, I wanted to print 10 sheets of an excel file in to 10pdfs with their sheet names at a time. Usually I print 10sheets in to 10pdfs 10 times everyday. Now I wanted to do it at once. Is that possible?

[OTrieger]

@Ayaanarjun-5885 
Yes, it is possible, you can do it with a Batch Macro.
Generating the PDFs can be done with Reporting tools or with Python tool.

[Ayaanarjun-5885]

Can we do that directly in an excel workbook

[OTrieger]

If you will use Python tool you can get Python to open the excel file based on the path and generate the PDF, if you have the proper Python packages.
Another option will be Run Command tool that will call excel.

[OTrieger]

Another option is not with Alteryx but Power Automate

[Ayaanarjun-5885]

Can we not do it without using any tool but only in excel workbook 

[OTrieger · Accepted solution]

Yes, if you know writing VBA code you can do it in excel.

[Ayaanarjun-5885]

Ohh Okay...Thank you so much for the assistance