I have some code (using FSO) that traverses windows folders and lists filenames with dates (modified, created, accessed).
I found out that this doesn't work for files in SharePoint and Teams. Found code that first maps a drive, and then un-maps after I'm done. That seems to work for Teams but not for our SP site where I have a URL that ends in ".aspx".
Anyone who can help me understand? Tips to fix this and/or workarounds or other ways?
Getting some file properties... in SharePoint or Teams
-
- BronzeLounger
- Posts: 1242
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Getting some file properties... in SharePoint or Teams
Try using the UNC path to SharePoint instead of the https address.
Set folder = fs.GetFolder("\\SharePointServer\Path\MorePath\DocumentLibrary\Folder")
Set folder = fs.GetFolder("\\SharePointServer\Path\MorePath\DocumentLibrary\Folder")
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1242
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Getting some file properties... in SharePoint or Teams
Is there a call that converts "https:" type strings to UNC paths? That would solve all my problems...
(And how do I get the UNC path in the first place? Does that work for Teams too -guess one should go to the Team SP that's behind all of that?)
PS. I don't see the "Open in Explorer" option enabled anymore. That did work in the past
(And how do I get the UNC path in the first place? Does that work for Teams too -guess one should go to the Team SP that's behind all of that?)
PS. I don't see the "Open in Explorer" option enabled anymore. That did work in the past
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1242
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Getting some file properties... in SharePoint or Teams
Anyone else who might have suggestions maybe?