Excel VBA and Sharepoint
I have an Excel document that has VBA codes. When the user click the button, the codes will first create a folder in a specific drive on the server (if the folder does not exist) and then save it in the created folder.
I wish to make the codes do the same but in Sharepoint instead; I mean create a folder in the document library and then save the document.
My first question: does Excel VBA codes work with SharePoint?
Secondly, I cannot find a book that explains how to write a code in Excel VBA that would communicate with SharePoint. Do you know or recommend any book that addresses this issue?
Thirdly, does sharepoint 2007 has a macro?
Any advice or explanation on the above would be appreciated.