communication with MS Project

A

Anne

Hi,

I have an application in Excel which communicates with MS
Project. The syntax might be correct (no error message),
but it is not executed. I cannot imagine why and I find no
hint in the object catalogue.
My code:

Dim Projekt As Object
' start Project
Set Projekt = CreateObject("MSProject.Project")
Projekt.Application.FileOpen newTimeSchedule

'*****this is the part which is not executed
If Check_TP_A.Value = False Then 'CheckBox
Projekt.Application.SelectTaskField Row:=0,
Column:="Name"
Projekt.Application.SetTaskField Field:="%
Abgeschlossen", Value:="100", AllSelectedTasks:=True
End If
'*****
Projekt.Application.FileClose pjSave
'Close MSProject
Projekt.Application.Quit pjDoNotSave

Thanks for every hint!

Anne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

communicate from Word with MS Project 2
Creating a project using ASP 0
Can not check in a project with VBA 4
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. 1
Editing Project Plans without MS Project 6
Need Project 2003 COM object but not Project 6
MS Project object creation failure. 0
Addin to MS Project 3

Top