时间戳

首页 > 解决方案 > VBA：将 .MPP 文件另存为 Excel 工作簿到 SharePoint 链接

vba - VBA：将 .MPP 文件另存为 Excel 工作簿到 SharePoint 链接

问题描述

最终目标是将项目文件作为 excel 文件直接保存到 SharePoint。我了解将项目文件保存到 SharePoint 的代码：

FileSaveAs Name:="https://[Directory]/Testing.mpp", FormatID:="MSProject.MPP"

但是当我将文件格式替换为 .xlsx 时，出现 1004 方法错误：

Private Sub Project_BeforeSave(ByVal pj As Project)

    MapEdit Name:="Map ", Create:=True, OverwriteExisting:=True, DataCategory:=0, CategoryEnabled:=True, TableName:="Task_Table1", FieldName:="Outline Number", ExternalFieldName:="Outline_Number", ExportFilter:="All Tasks", ImportMethod:=0, HeaderRow:=True, AssignmentData:=True, TextDelimiter:=Chr$(9), TextFileOrigin:=0, UseHtmlTemplate:=False, IncludeImage:=False
    MapEdit Name:="Map ", DataCategory:=0, FieldName:="Name", ExternalFieldName:="Name"
    MapEdit Name:="Map ", DataCategory:=0, FieldName:="Start", ExternalFieldName:="Start"
    MapEdit Name:="Map ", DataCategory:=0, FieldName:="Finish", ExternalFieldName:="Finish_Date"
    MapEdit Name:="Map ", DataCategory:=0, FieldName:="% Complete", ExternalFieldName:="Percent_Complete"
    MapEdit Name:="Map ", DataCategory:=0, FieldName:="Duration1", ExternalFieldName:="Duration1"
    FileSaveAs Name:="https://[Directory]/Test.xlsx", FormatID:="MSProject.ACE", map:="Map "
    
End Sub

有人可以解释什么是错的吗？任何帮助表示赞赏。

标签： vbasharepointms-project

解决方案

推荐阅读