Getting some file properties... in SharePoint or Teams

User avatar
ErikJan
BronzeLounger
Posts: 1242
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Getting some file properties... in SharePoint or Teams

Post by ErikJan »

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?

User avatar
HansV
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

Post by HansV »

Try using the UNC path to SharePoint instead of the https address.

Set folder = fs.GetFolder("\\SharePointServer\Path\MorePath\DocumentLibrary\Folder")
Best wishes,
Hans

User avatar
ErikJan
BronzeLounger
Posts: 1242
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Re: Getting some file properties... in SharePoint or Teams

Post by ErikJan »

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

User avatar
HansV
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

Post by HansV »

No idea, sorry.
Best wishes,
Hans

User avatar
ErikJan
BronzeLounger
Posts: 1242
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Re: Getting some file properties... in SharePoint or Teams

Post by ErikJan »

Anyone else who might have suggestions maybe?