如何使用VBA获取SharePoint中文件的最后修改日期？ [英] How will I get the last modified date of a file in a SharePoint using VBA?

问题描述

我想在Sharepoint中获取文件的最后修改日期时寻求帮助。我将使用什么VBA代码/命令来执行它。
当单击命令按钮时，我想在MsgBox中显示该文件的上次修改日期。

您的迅速回应非常感激。

解决方案

我一直在试图弄清楚一段时间，我偶然发现了另一个调查领域的引导我

在您的VBA窗口中，转到工具 - >引用，然后向下滚动并选中Microsoft Scripting Runtime旁边的框。 >

然后当您指定链接时，将会如下所示：

FileDateTime（/ /site.com/page/file.xlsx ）。

否http：一旦我这样做，它就像一个魅力。

I would like to seek help regarding on getting the last modified date of a file in a Sharepoint. What VBA code/command will I use in order to execute it. I would like to show this "Last Modified Date" of the file in a MsgBox when a command button is clicked.

Your prompt response is very much appreciated.

解决方案

I've been trying to figure this out for a while and I stumbled upon something in another line of inquiry that led me to a solution.

In your VBA window, go to Tools -> References, and then scroll down and check the box next to "Microsoft Scripting Runtime".

Then when you specify your link it's going to read like this:

FileDateTime("//site.com/page/file.xlsx").

No "http:" Once I did that, it worked like a charm.

这篇关于如何使用VBA获取SharePoint中文件的最后修改日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！