I'm trying to save a workbook on sharepoint as a PDF (which I have working using this path \\xxxx.sharepoint.com\sites\xxxx\Shared Documents\) but when someone has the PDF open on either a network share or sharepoint I get the "document not saved" error.
My question is, do I just have to wait until it's closed or is there a workaround to overwrite it.
I have tried used the following code but I still get the same error.
I am creating a PDF for people to access in sharepoint as the main workbook resides on a network share which is not available outside of the organisation.
There could possibly be 100+ people who may need to access it.
If this is not workable would people have any other suggestions. I want to use a PDF as people just need the info and not access to the workbook.
My question is, do I just have to wait until it's closed or is there a workaround to overwrite it.
I have tried used the following code but I still get the same error.
VBA Code:
SetAttr PathName:=sExportFullName, Attributes:=vbReadOnly
I am creating a PDF for people to access in sharepoint as the main workbook resides on a network share which is not available outside of the organisation.
There could possibly be 100+ people who may need to access it.
If this is not workable would people have any other suggestions. I want to use a PDF as people just need the info and not access to the workbook.