Using Excel for Mac 2011 I have created a single page report that i want to save as a pdf using a macro. I want to save to a folder called "Report" on the desktop. On a PC i can use the GetOpenFilename command to select the folder and then the code will create a file with a specific filename (taken from a cell within the sheet). I am having trouble doing this on a mac however - i know there is some commentary online about this matter but i have so far been unsuccessful.
How to specify the filepath
VBA syntax for creating the pdf
Help and guidance would be appreciated.