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.