I've been trying to create files from Excel to our company SharePoint site on Office 365, so far without success. Here is the code:
Please Login or Register to view this content.
I get a runtime error at this line:
If Dir(sDC01 & sYear, vbDirectory) = "" Then
I've tried this as well:
https://CompanyName.sharepoint.com/s...mpusEng/Shared Documents/Campus Compliance/Generator Run and Training Logs/
The code has to be able to run for whomever opens the file in the company, so I cannot use a local directory to save.
You can also find the post here.
Bookmarks