johhnn
03-24-2018, 03:59 AM
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,
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,