Customize a field from VBA

[Mohammed El-Beghdadi]

Hi all,

I want to customize a field, change it's value to be a formula; but I want
to do it from Access VBA; I have bee searching the fields in the different
tables but was not successful so far. ( I basically want to automate the
manual process of clicking on Customize field, then clicking on formula and
putting the formula in)

any help would be appreciated.

 

[Jan De Messemaeker]

Hi Mohammed,

Best is first to create a reference to MS project library in your VB Editor
Then through Object Browser you will have access to MS project Help
Not that we aren't willing to reply but if you will have to ask a question
for each method you look for your development may be a lengthy business )

In this case you need the customfieldsetformula method which applies to the
application object.

Details on how to addres sthe field and enter the formula are found in the
Help files.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"Mohammed El-Beghdadi" <[email protected]>
schreef in bericht

Hi all,

I want to customize a field, change it's value to be a formula; but I want
to do it from Access VBA; I have bee searching the fields in the different
tables but was not successful so far. ( I basically want to automate the
manual process of clicking on Customize field, then clicking on formula and
putting the formula in)

any help would be appreciated.

eternal.

 

[Mohammed El-Beghdadi]

Hi Jan,

You know Jan, You've opened such a nice window of help for me, I thought I
knew VBA .

Thanks for your help, and no, I wont be send a question about each function
of the library!!

Best Regards,