How to convert multiple excel file to a PDF file

[Zyeuxrouge]

Hello,

i want to convert each excel to a pdf, Excel1.xlsx -> Excel1.pdf ... Excel2.xlsx -> Excel2.pdf etc ...

is there a way to it like with a loop please ?

thanks in advance !

 

[6StringJazzer]

It can be done in a loop if there is a way to determine which Excel files you want to convert. Do you have a folder with these files? A list of file names? How do you know which files?

 

[Zyeuxrouge]

Thanks for your response,
Yes i have a folder with those files, named each Excel1, Excel2 ect..

 

[6StringJazzer]

Note that you don't convert a file to PDF, you convert a worksheet (or multiple worksheets). What worksheets do you want to convert from each file?

 

[Zyeuxrouge]

i actually found a reponse in another thread, and it actually works fine
here the link : VBA - Convert Excel Files to PDF
thanks for your response !