Sleeper: Writing File Address to Save File Directly to a Shared Folder
My users are sparse in their understanding of computers. I gave them a Form in Excel to use and included a "Save As" button. I want the VBA attached to the button to have the File Explorer open to a shared folder on SharePoint that all users have access to. I thought that would be easy, but the File Explorer only opens to their respective Documents folder which means the user then needs to browse to the needed folder to save the Form, which is problematic for some users. Any assistance, if this is possible, would be greatly appreciated.
Thank you.