I need VBA Code that will save the excel workbook that is active to a specific SharePoint site. BUT
The site needs to be identified using the URL and the text in sheets(“Step 7”).range(“c21”)
[login to view URL]
Then it must show the new concatenation path in Sheets(“Step 7”).range(“c25”) as a active hyperlink
And it must name the workbook the text value in sheets(“Step 7”).range(“d11”)
If there is not a sharePoint site with the concatenation address Then error message stoping code and telling the user to check the sharePoint site to validate that there is a folder by the name of the value in C11
Note C11 is the folder name that needs to be concatenated with the URL pasted above.
C12 is what the workbook should be named - saved as.
NEED IT TODAY