Hello everyone.
I need a vba command that when activated it does the following:
1) Saves a selected range of cells, in this case it is on a sheet call Reports in cells A1:I93, as a pdf on the desktop in a folder titled Test.
2) The name of the PDF is in cell J86 also on the Reports worksheet
3) All of the options for creating the pdf should be their defaults. So all I have to do is click the button and the pdf is created.
The trick is that it has to work on a MAC with Office 2011
Thanks again.
I need a vba command that when activated it does the following:
1) Saves a selected range of cells, in this case it is on a sheet call Reports in cells A1:I93, as a pdf on the desktop in a folder titled Test.
2) The name of the PDF is in cell J86 also on the Reports worksheet
3) All of the options for creating the pdf should be their defaults. So all I have to do is click the button and the pdf is created.
The trick is that it has to work on a MAC with Office 2011
Thanks again.