Hi Guys,

I need a macro to save a sheet print area to a Sharepoint Library as a PDF.

I currently have the following Macro saving to a local directory:

Please Login or Register  to view this content.
So what I want to do is refer to a dynamic Sharepoint URL field in my workbook (the third line in my code above is where the macro finds the dynamic filename and path) and save the PDF here rather than in the local directory as it does now.

This is way above my level of expertise, so any help would be appreciated.

Thanks