How to convert excel and word files together to the same pdf using excel VBA?

[vergab]

Hi,
I want to convert several files (word and excel mixed) from a folder to a pdf file. This folder contains 3 word files and 9 excel file. I need to create 3 pdf files each contain 1 word and 3 excel files in the same order as in the folder. I know the code for converting word and excel to pdf separately, but how can I convert them together?

 

[Macropod]

Vergab: You have asked the same question twice. Please read our policy on duplicate threads in rule #12: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

You may continue the discussion in your other thread: http://www.mrexcel.com/forum/genera...df-using-excel-visual-basic-applications.html

Thread closed.