ExportAsFixedFormat 0, Environ('USERPROFILE') & '\Dropbox (TJM)\TJM Team Folder\TM\TJM Filing Structure\6. The code that works on the PC is as follows: With employees using PC's and MAC's, I wondered if there was a code I can use which will work on both or, a code that will work on the MAC and I can just add another button in the sheet for MAC users. I have a macro which enables me to save the current worksheet as a PDF using a couple of cells for the file name and saving to my business drop box location however, this does not work on the MAC. Hi guys, I'm new to the forum and forums altogether so excuse any mistakes, I've read the rules so fingers crossed.
