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:
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.
Any help with this would be greatly appreciated.
Thanks
Bookmarks