Checking for ActiveProject

[Ben]

Hi,
I have some VBA code that runs through the tasks in the active project.
This is deployed via the Enterprise Global Template (via Project Server).
The VBA code is fired on the BeforeSave event. After I've closed the
project, and then close winproj, I get an error. How do I check that an
ActiveProject exists?

 

[HansH]

Hi Ben,

Try this:

If Application.Projects.Count > 0 Then
<insert your code here>
End If

Kind regards,
Hans

Projectopolis <http://msepm.hsquared.be>

 

[HansH]

Hmm,
Ignore my answer... didn't notice Jan already answered in your double
post

Projectopolis <http://msepm.hsquared.be>