-
MS Project Tasks Extraction into Excel
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,.....
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules