VBA macro using .Net language

[Coolpran]

I know I'm going to get a lot of flak for this... but is there a way to write
a macro which can leverage VB.Net or C#?

I need to design a complex form which will run when a toolbar button is
clicked, and it would be much simpler if I can use the rich controls of .Net
framework.

I know I can write the code separately as a Windows Forms control, generate
a CCW and reference it in my MS-Project VBA editor, but this means I will
have to distribute the CCW dll file to all the users (which I want to avoid)

Oh, the environment is Project Server 2003 with Project Pro 2003 clients
with the end-users being widely distributed.

So the solution should be such that only the Enterprise Global needs
changing. This means the solution is then is automatically deployed whenever
the user connects to the Project Server.

Any thoughts on this one?

 

[Rod Gill]

Hi,

The only way right now is to use VB.Net to create an Add-in. I'm not sure
however how add-ins interact with Project Server. I assume they still need
installing on each copy of Project Professional.

Use VB rather than C# as VB has optional parameters, better intellisense and
is therefore faster to develop with but same performance.