View Single Post
  #1 (permalink)  
Old April 5th, 2013, 04:29 AM
Khalil Khalil is offline
Authorized User
Points: 378, Level: 6
Points: 378, Level: 6 Points: 378, Level: 6 Points: 378, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Dec 2009
Posts: 67
Thanks: 6
Thanked 0 Times in 0 Posts
Default Excel VBA and Sharepoint

Hi All,
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.