The following VBA segment reports run time error when MS Project is not Open. It works as it should when MS Project IS open. Any education 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: " & Cells(4, "L")
End If
Set aProj = ProjAppl.ActiveProject '**** - Returns 424 run time,.....
Thanks & Regards,
fPath = Cells(4, "L")
If fPath = "" Then
MsgBox "No File Specified"
Exit Sub
Else
ProjAppl.FileOpen fPath
'MsgBox " MS Project File Opened Successfully: " & Cells(4, "L")
End If
Set aProj = ProjAppl.ActiveProject '**** - Returns 424 run time,.....
Thanks & Regards,