I have some code that exports Excel info to MS Project, if MS Project is open. If MS Project does not exist on the computer this code generates an error in the Set projApp line. Why does it ignore the On Error Resume Next line? This is part of a significant application that needs to work on computers with and without Project. This particular function needs to run only if MS Project exists and is open.
Thanks
Ken
Excel Formula:
Dim projApp As MSProject.Application
On Error Resume Next
Set projApp = GetObject(, "MSProject.Application")
On Error GoTo 0
If projApp Is Nothing Then
Exit Sub
Else
Thanks
Ken