MS Project的Sharepoint Datamine [英] Sharepoint Datamine for MS Project

问题描述

大家好

我正在VB中编写一些报告，使用连接到某些sharepoint寄存器的excel数据挖掘。  我们使用存储在sharepoint上的标准MS项目文件。

I am writing some reports in VB, using an excel data mine which is connected to some sharepoint registers.  We use standard MS project files which are stored on sharepoint.

我知道你可以这样做使用MSP在线，但无论如何都要使用标准ms项目.mpp文件创建数据连接，以便excel自动刷新，以便我可以将数据用于报告目的吗？

I know you can do this with MSP online, however is there anyway to create a data connection with a standard ms project .mpp file so excel auto refreshes so I can use the data for reporting purposes?

问候

Sean

推荐答案

Sean，

抱歉，没有。除了Project Online，您可以使用VBA将数据复制到SQL Server或Excel以进行报告。

Sorry, no. Apart from Project Online you can use VBA to copy data to SQL Server or Excel for reporting purposes.

这篇关于MS Project的Sharepoint Datamine的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！