Pull external file data using a URL

Good day,

I have a spreadsheet being used to track the status of web pages. I need a function to go out and find the date modified of the URL’s listed in a cell (if column A is the URL, column B will be the cell that the function is applied in to find the date column A was modified).

I am already able to do this for files that we host locally using the following code in a module (column A being a path rather than a URL):

Please Login or Register  to view this content.

I need to be able to use this function with external pages, as well as allow people outside my local network to use the spreadsheet's functionality (i.e. URL only, no local access).

I greatly appreciate any assistance with this.

Respectfully,
-Joe Kelly

I made some progress on this. The code below is able to return the date, but it returns the current date. I am not sure if this is due to the URLs being SharePoint sites or what?

Please Login or Register  to view this content.

Any insight into making this work would be greatly appreciated.

-Joe

Hi Joe,

Did you get this working?

Cheers,
Mark

Originally Posted by britinva

Hi Joe,

Did you get this working?

Cheers,
Mark

Mark,

Never did get it to work. I ran out of time (only so many hours can be billed for research). We needed to move forward with the project, so at this point it is just being done manually.

Thanks,
Joe