Hello,

I'm new in VBA and macros, i have just done an easy project using help from this forums and from internet but now i need some help with a more complex task.

I have different excel workbooks, each with 2 or more tabs, and I want all these excel files from a specific location to be converted to PDF format (no opening them), not to a single PDF, but each excel file to its own PDF and then send each of them by email to different recipients. I would have a column to match each file name with the recipient's email or name.

I have excel 2007

Thanks very much!
M.