VBA to Send eMail with PDF Attachment from SharePoint File

[Gtrtim112]

Happy New Year!

I believe this is relatively simple so I'm hoping someone can solve it for me.
I have the code below in a workbook, which saves the Excel sheet as a PDF and then attaches to an email in Outlook. I've used this code for years with no issue but the file has always been on a local hard drive when the macro was used.
The file I'm using today is stored in SharePoint and used by various people. For some, the macro isn't working at all. My assumption is that it's having an issue when trying to create the temporary file name to SharePoint, then kill that file name.

Can someone look at the VBA code here and suggest a way to make the temporary file path direct towards the local drive versus the SharePoint site that the file is located in?

Thank you for taking a look!

Please Login or Register  to view this content.

[JEC.]

What if you run this? You can't use kill on sharepoint web links.

Please Login or Register  to view this content.

[Gtrtim112]

What if you run this?...

Perfect... so much more simple coding also.

Thank you very much for the quick reply!

[JEC.]

You're welcome! We like simple