Hi
I am trying to find a macro to save a work sheet as PDF to a location on my drop box which works on my PC but not the MAC. A few people in the office use MAC so I need to make the macro compatible with MAC or offer two buttons on the sheet to choose from (MAC or PC).
The code I am using which works on the PC for this particular work sheet and location is:
The file saves as a PDF in the correct folder (purchase orders OUT) and the file is named as the PO number (L13), the client name (W2) and todays date. What I want to do is create a macro which will work on the MAC and save to the same location.
Any help would be greatly appreciated.
Thank you
Terry
Bookmarks