Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
other
informationbridge
office.intranets
office.misc
office.setup
office.xml
officeupdate
onenote
photodraw.discussion
powerpoint
producer
proj.standard&server
project
project.developer
project.pro_and_serve
project.server
project.vba
project2000
publisher
publisher.prepress
publisher.programming
publisher.webdesign
visio
visio.createshapes
visio.database.modeling
visio.dev.diagrams
visio.dev.shapesheet
visio.dev.vba
visio.dev.vc
visio.developer
visio.general
visio.installation
visio.printing
visio.software.modeling
visio.troubleshoot
  
 
date: Mon, 16 Jan 2006 09:52:23 +0100,    group: microsoft.public.project.vba        back       


MS-Project VBA Question   
Hi NG ,
I am new in the field of VBA and have a question / problem.
In one project file I defined a field ( customized field Number 13 )
and renamed it as "StatDur" and entered a formula there in.
With VBA I want to read out the contents of this field and display
it via MsgBox. Ihave entered following code

num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13, 
pjValueListValue, 3)

Syntax is :
Ausdruck .CustomFieldValueListGetItem(FieldID, Item, Index)

Thats my code entered in VBA ( as above ):
num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13, 
pjValueListValue, 3)

I want to store the contents of this field from row 3 in num and want to
display it via MsgBox.

It wont work since the VBA-Editor brings a failure where I am entering the 
row number 3
as Index and I dont know why and how to solve this problem.
Can onyone give a helping hand.
Thanks in advance
Gru

-- 
Cevikel
Tel. : 0911-433-6329
mailto:halidun.cevikel@siemens.com
date: Mon, 16 Jan 2006 09:52:23 +0100   author:   Cevikel

Re: MS-Project VBA Question   
Hi Cevikel ,

Try posting on the developer newsgroup as this one is closing down.  Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

Cevikel wrote:
> Hi NG ,
> I am new in the field of VBA and have a question / problem.
> In one project file I defined a field ( customized field Number 13 )
> and renamed it as "StatDur" and entered a formula there in.
> With VBA I want to read out the contents of this field and display
> it via MsgBox. Ihave entered following code
>
> num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
> pjValueListValue, 3)
>
> Syntax is :
> Ausdruck .CustomFieldValueListGetItem(FieldID, Item, Index)
>
> Thats my code entered in VBA ( as above ):
> num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
> pjValueListValue, 3)
>
> I want to store the contents of this field from row 3 in num and want
> to display it via MsgBox.
>
> It wont work since the VBA-Editor brings a failure where I am
> entering the row number 3
> as Index and I dont know why and how to solve this problem.
> Can onyone give a helping hand.
> Thanks in advance
> Gru
date: Mon, 16 Jan 2006 09:44:00 -0000   author:   Mike Glen glenATmvps.org

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us