Publishing a Project using VBA - Publish Project Dialogue

[Carl Sprake, Oxford, UK]

Hi,
I am trying to write a macro that will automatically publish a project.

We are using Project Server 2007 but we are not using workspaces (and I have
set this option in Server Settings - Workspace Provisioning).

What I would like to happen is for the macro to publish the project without
displaying the Publish Project:<project name> dialogue box. And act as if the
user keeps the option "Do not create a workspace at this time" and clicks on
the Publish button.

I have tried using SendKeys and I could not get that to work.

Thanks for your help.

Carl

 

[Jan De Messemaeker]

Hi,

This worked last year, hope it still does:

VBA.SendKeys "{ENTER}{TAB}{ENTER}"
FileSaveAs Name:=("<>\" & "_" & DeNaam), FormatID:=""
VBA.SendKeys "{ENTER}"
Publish


Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf