PDA

View Full Version : MS Project Tasks Extraction into Excel



Anwer
09-08-2016, 02:16 PM
MS Project - Tasks Extraction into Excel

The following VBA segment returns a run time error when MS Project is not Open. It works as it should when MS Project IS open. Any insight on what is causing it and how could it be amended to NOT to require opening MSP, shall be greatly appreciated.

fPath = Cells(4, "L")


If fPath = "" Then
MsgBox "No File Specified"
Exit Sub
Else
ProjAppl.FileOpen fPath
'MsgBox " MS Project File Opened Successfully: " & fPath
End If

Set aProj = ProjAppl.ActiveProject '**** - Returns 424 run time,.....