Convert VBA to a .NET language

Question

Possible Duplicate:
Is it possible to convert VBA to C#?

Suppose I have a big VBA project and want to convert it to a .NET language. Is there any way to do it automatically? Or maybe could I generate UML and a class structure, then append method bodies by hand?

Solution

I don't think there's a provided way to migrate VBA to .NET, but there are conversion tools online that might help as a syntactical reference for parts of the code. This approach will be cumbersome, but it might still be easier than doing it all by hand.

Here's an article that discusses migrating VBA to VB.NET:
http://msdn.microsoft.com/en-us/library/aa192490%28v=office.11%29.aspx

Converters

Here's a VB.NET to C# converter:
http://www.developerfusion.com/tools/convert/vb-to-csharp/

And here's another one:
http://converter.telerik.com/

I don't know how helpful the converters will be since they're designed to convert .NET languages to other .NET languages, but seeing as how VBA and VB.NET do share some similarities, you might be able to use the converter for some of the code.

Comments

[George Duckett]

@JamesHill: Presumably because the first link is VBA to VB.NET, so it'd be VBA->VB.NET->C#

[James Johnson]

@JamesHill: I didn't say that they were the solution. I just said that they be useful for parts of the migration.

[N_A]

There are vb6->C# converters out there. We used one at my former company.