VBA 将 excel 前身数据导出到 MS Project

目前我的 excel 中有 4 列，即（ID 列可以忽略）

我希望在我的 Excel 中创建一个宏按钮，以将内容直接导出到 MS Project 中。我只能在网络上找到有关仅传输任务的共享。有人可以帮助我吗？真的很感激。

我现有的代码（归功于#madschedules），其中仅包含任务。

Sub createNewMSPFromExcelData()

' First go turn on the MS Project reference library

' Declare variables
Dim pjApp As MSProject.Application
Dim pjProject As MSProject.Project
Dim pjtasklist As MSProject.Tasks
Dim pjtask As MSProject.Task
'Dim pjpredlist As MSProject.TaskDependencies
'Dim pjpredlist As TaskDependencies
Dim pjpred As TaskDependency
Dim xlrange As Range
Dim xlrow As Long
Dim counter As Integer

'open MS Project application
Set pjApp = New MSProject.Application
pjApp.Visible = True

' Add a new project file
Set pjProject = pjApp.Projects.Add
Set pjtasklist = pjProject.Tasks


'Loop through all the Excel Data in the worksheet
counter = 2
Do Until Cells(counter, 1) = ""
    Debug.Print Cells(counter, 1).Value & "   " & Cells(counter, 2).Value & "   " & Cells(counter, 3).Value

    ' Add new task into MS Project from Excel Value
    pjtasklist.Add (Cells(counter, 2).Value)
    pjpred.Add (Cells(counter, 3).Value)

    counter = counter + 1
Loop

MsgBox ("There are " & pjtasklist.Count & vbNewLine & _
       " tasks in our new project")

End Sub

MS Project 图像中的预期数据

为了回答前辈，我目前正在做一个涉及多层次的电子原理图设计项目。因此，要在层次结构上工作，我需要确保在进行下一个层次之前完成子层次结构的活动，因此我将前辈的详细信息从原理图导出到 Excel 中。