Hi, I have been looking around for a few weeks now and have not found any real, up-to-date solutions so apologies if I have missed something.

I am looking to create a macro that allows the user of the form to save a local, editable copy of the sheet as an xlsm document (which I already have in place) and also saves a PDF export to a SharePoint online site for other colleagues to access. I don’t yet have a SharePoint site to test this on as I need to gain authorisation to open one first but I just wanted to find out if this would be at all possible? The PDF export would be updated by each user on a weekly basis under the same filename, I trust that this would not pose an issue and would just request to replace the old document?

I have a code setup that I have been testing that creates a local PDF export and was just wondering if this could be amended when I have a SharePoint site set up for it?

Current code:
Please Login or Register  to view this content.
Would it just be a case of amending this code to include the SharePoint address as below or is it not quite as simple as that? Apologies if this is a simple question but I have little experience with SharePoint Online as it is relatively new to my employer.
Please Login or Register  to view this content.
Any help with this would be greatly appreciated.
Thanks