VBA to Export and Save as PDF

Hi All,

As the title suggests, I am looking to export and save an excel sheet as a PDF to a specific file location.

I am currently using the code below, which works perfect, however I would like to know if there is a way to redirect the save to open a "save as" box should an error occur trying to save to the location listed

Please Login or Register  to view this content.

The reason I ask this, is I am saving the PDF to a Synced SharePoint folder on the users computer, should this fail to sync or be removed by mistake, I dont want my code to return an error, and instead redirect to a manual save as box

Thanks in advance to any replies

It's 1:30am & here I am looking at macro code, I modified some code I already had & tested it as best I can. Hopefully it's what you're after

Please Login or Register  to view this content.