VBA To Check File Exists In Sharepoint

Hi Folks,

Does anybody have some VBA code that checks if a file exists in Sharepoint?
I thought this would be a simple task but it's proving to be quite a challenge.

Do you mean that you have just a filename, but you don't know where it's located, and you want to search for it? Or do you mean that you have a file name and location and want to see if it is actually there?

SharePoint is basically a web site and VBA does not have built-in features to search a web site. There may be an add-in or something available if you need to search.

I have a file name and location and want to ascertain if the file exists.

This will check if a file exists at a specific URL:

Please Login or Register  to view this content.

Many thanks.
I'll try this.

I've tried this Function and it always tells me the file exists at the URL irrespective of whether the file actually exists.
Am I missing something?
Is there a Reference that needs to be activated?

My URL looks like this "https://company.sharepoint.com/sites/ESUTeamPlanning/Shared Documents/ESU Files/Costing & Reporting/NG/Invoicing/2022/STTM/202203/MSV/QEN/20220323 MSV.pdf".

There is no reference needed. I did some testing on this for files in a public web site and it worked fine for me. I wonder if there is an issue related to the fact that you have to login to the site.

Atik, possibly, but this code does not use a browser, it sends the HTTP directly. I'm not sure if VBA maintains a cache.

In a worksheet cell, it should be:

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by sarante

Could you please explain how to test the coding 6StringJazzer posted? Thanks.

Welcome to the Forum sarante!

Normally we prefer that new questions go in a new thread (please read the rules), especially since this thread is over 18 months old. But since your question is directly about an answer posted for the OP, and not some new twist, it should be fine.