Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
"Soft Code" Find File Directory Or Alternative | Excel Programming | |||
"Design" manual disappeared/gray out after exporting to Sharepoint | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Directory "Locked" when selecting multiple files using GetOpenFilename | Excel Programming |