Macro to Export and Save as PDF - MAC and PC USERS

Hi guys,

I am trying to write a macro that will export a sheet into pdf format and save it (preferably to desktop) automatically.

The problem I have is that the file will be used on both PC and Mac, different computers, different users, different OS's.... Can this be done?

Even though I would prefer the whole thing to be done automatically, I don't mind if the macro prompts the user to select where the file will be saved (save as) the first time they click on the "save and close" button I will create and then just (save) any time it is pressed after that....

Any advice or help on this would be greatly appreciated.

Hey guys,

sorry any tips on this?

...Just bumping this back to the top... hope that's ok.

Sorry guys, been trying to find a solution to this for a while - its doing my head in .

Any help at all would be greatly appreciated