View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Amedee Van Gasse Amedee Van Gasse is offline
external usenet poster
 
Posts: 49
Default Creating a new "directory" on Sharepoint

On Sep 23, 4:54*pm, Joel wrote:

* * 'determine if it exists
* * DirectoryExists = objFSO.FolderExists(PathName)


The method FolderExists works for SharePoint folders.

* * if right(Folder,1) = "\" then
* * * *Folder = left(Folder,len(Folder)-1)
* * end if


That should be:
If Right(Folder, 1) = "\" Or Right(Folder, 1) = "/" Then
because a Sharepoint path is an URL with forward slashes.

* * objFSO.Add(Folder, Path)


The methods Add and GetFolder give an error 76 (path not found) when
they are used on SharePoint folders.

But then I had a brilliant idea. I can also access the Sharepoint
directory via UNC notation too: \\teamsites.company.tld\sites
\department\project
This works. Thanks for tuning in.