Should I use the PSI or VBA?

[tfz]

I'm attempting to import actual time data into Project 2007. I understand
that I should be able to do this either using the PSI and web services, or
through VBA. Can anyone tell me the relative merits of each method? I have
heard that VBA is slower, but using C# might be harder to maintain. (We have
the expertise to write code in C#/Webservices or VBA, so that's not an issue.)

Thanks for the information.

 

[Scott Wagner [MCP, MVP]]

There are several reasons that I would recommend the PSI and C#:
1. Regions in C#: The key here is that you can place a region inside a
function, thus breaking up the implementation into logical pieces.
2. Error Catching for C# is better
3. C# has Operator Overloading feature
4. Multi-line comments
Many more but that's a good start.

 

[Rod Gill]

Hi,

Scott's reasons are very valid if you have Project Server 2007 and
professional programming services that know C# and use of Web Services.
However, VBA:

Works for all versions of Project from 98 onwards
For running code on the active project is as fast as C# or faster as it runs
in the same process as Project
Is easier to develop in as Intellisense and named parameters lead to quicker
creation and easier to read code
Is better for working with other Office applications for similar reasons as
above
If you know VBA for any other application, picking up Project VBA is
relatively easy
Many more but that's a good start!!


--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

There are several reasons that I would recommend the PSI and C#:
1. Regions in C#: The key here is that you can place a region inside a
function, thus breaking up the implementation into logical pieces.
2. Error Catching for C# is better
3. C# has Operator Overloading feature
4. Multi-line comments
Many more but that's a good start.

--
Have a great day!

Scott M. Wagner [MCP, MVP]

I'm attempting to import actual time data into Project 2007. I
understand
that I should be able to do this either using the PSI and web services,
or
through VBA. Can anyone tell me the relative merits of each method? I
have
heard that VBA is slower, but using C# might be harder to maintain. (We
have
the expertise to write code in C#/Webservices or VBA, so that's not an
issue.)

Thanks for the information.