Hi all,

Im having some troubles with using VBA on MAC(Yosemite 10.10.5). Im new to the coding and I need an macro for excel 2011 (14.1.0). Does anyone know a macro that does the following thing in excel:

-Export the excel sheet (with print range) to pdf.
-Export to a specific map.
-The file named based on the value of a cell.
-Open the PDF file on screen. (somehow the code openafterpublish didn't work in my code)

Much appreciated,

John,