Project - project server VBA compatibility 2003 / 2007 /2010

Hi all,
I have developped several macros in VBA for project server 2003.

My company has in mind to migrate to project server 2010. Have anybody had a
feedback about compatibility problems for VBA. The 'project functions' I have
used are mainly : task, timescaledata and predecessortasks. I have also a
form with a listbox.

I think this would be ok to just transfer my 2003 macros to 2010 but ... you
never know...

  Rod Gill replied to Christophe CHAURE

So far, my testing suggests 2010 runs old code fine, but final say so has to
wait the final version!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com





__________ Information from ESET Smart Security, version of virus signature database 4697 (20091217) __________

The message was checked by ESET Smart Security.

http://www.eset.com

TimeScaleData in MS Project shows "Unexpected error in method" Project Hi there, using the VBA code for accessing time scaled data I encounter the above error message (Unexpected error in as 09-30-2008 until 09-30-2009 in US format). Set pTSV = .ActiveProject.ProjectSummaryTask.TimeScaleData("30.09.2008", I am using MS Excel 2007 andMS Project 2007. I have read using .NET. Any help appreciated, I am lost here. Reinhard Project Developer Discussions ActiveProject.ProjectSummaryTask.TimeScaleData (1) ProjectBudget.UpdateProjectData (1) Microsoft Project (1) Microsoft Excel (1) MPPKSTArray (1) System.GC.collect VB.NET (1) Hi, What's the error and on what line of code, the TimeScaleData line or a line reading the data? In VBA I do not know of any problem. I regularly produced code reading more than 9 for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 5035 (20100416) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com

to have changed any settings in global. Furthermore, the administrator is now claiming that local macros are probably causing this, without explaining how it happens (this is probably a political statement one that sets a time interval to show only "current-ish" tasks. Neither of these macros use any text fields. The time interval macro uses the Flag10 field. In the last opened it the next morning to find this had happened. He did not run any macros. I have never come across this issue before. Can anyone shed any light on what we are doing wrong? Thanks, Paul Project Server Discussions Project 2007 (1) VBA (1) Database (1) FAQs (1) NerHeThanks (1) PaulYou (1) PMs (1) Chefetz (1) If you have text for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 4986 (20100330) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com Ben. http: / / www.applepark.co.uk http: / / appleparkltd.spaces.live.com / he d ent re database 4986 (20100330) _ __ __ __ __ _ Thanks Rod, I know how to change the fields. It even comes

Enumerate Fields? Project Is there an easy way in VBA to enumerate all the available fields (names, aliases) in MS Project (i.e. "Number1", "Text2 for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 4869 (20100215) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com again, Eric No there is no list of used fields. You have to use some VBA to check them. I have a sample which is a good starting point here: http for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com Rod, If you can rely on a standard then so I cannot query a project for its fields, much like I can query an Access database table for its fields. I feel a painful bout of "manual labor" coming on. Regards for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 4872 (20100216) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com

Project Developer Help content Project Hi, I found recently that the help available in the VBA Editor has changed for the worse. It looks nicer, but is content free. For instance office.12).aspx) but it used to be easier to get it directly from the VBA Editor. Pressing F1 on an object or proporty would get you the details, now I 1) The Project Object Model reference (1) Neil, With the release of Project 2007, the VBA help file took a turn for the worse and from a recent comment by one of our premier VBA MVPs, Project 2010 is even worse. I would say that if you find a way you need, (e.g. MSDN), then go for it. If I have to write some VBA code in Project 2007 I revert back to the VBA help file in Project 2003. John Project MVP Me too John, Project 2003 VBA help is much better! Don't forget the object browser as another way to find for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature

TimeScaleData method in MOPS? Project I am trying to convert an existing mpp file, with its associated macros, into something that can be done on Project Server. So far, I have managed to create all the fields that were done via macros into custom fields on the server. The one thing I am left with is where the author of this file used the TimeScaleData method to calculate a custom field for BQWS. Is it possible to have an enterprise the baseline start date and the status date. Kevin Project Server Discussions Project Server (1) VBA (1) TimeScaleData (1) Database (1) FAQs (1) Chefetz (1) Idiosyncrasies (1) Auditable (1) I should note, Andrew helped me for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature