VBA Code Convert to VB.NET

[Muratti]

Hey,

I have a not sophisticated VBA code (integrated with Excel) that I would like to convert into VB.Net.
I have some questions:
Is the VB.Net Upgrade wizard applicable to convert VBA code as well?
How hard is it to convert to VB.Net?
SHould I first convert to VB6 and then to VB.Net?

I would really appreciate if anybody would help me. Thanks.

 

[KidCoder]

I think the convert wizard should be compatible with VBA. All you have to do to find out is open your VBA project in VB.NET. Its not hard to migrate - it does it automatically. You convert it to VB6 first ONLY if the wizard isnt compatible with VBA. Welcome to Were Here!

Kid

 

[Divil]

Its important to note that it is always better to rewrite, rather than convert. You learn more that way, and if you dont have time to rewrite, the project is probably left in whatever it was before.

 

[KidCoder]

Its true that its better to rewrite instead of convert, but Ive learned a lot more about coding structure of .NET much faster by migrating all my projects, and then studying the coding differences. Its almost like my own .NET forum!

 

[Divil]

Except that the conversion wizard doesnt convert to real .NET, it uses helper functions in the VB compatibility namespace which I dont think is redistributed.

 

[KidCoder]

OH! I didnt know that! Ill have to show this thread to my uncle, because he seems to think that its real .NET.

Thanks!

 

[Divil]

Its real .NET, but often a rather perverted version, designed to look more like VB6 code. This avoids the conversion wizard having to jump through hoops when processing old code. Its always better to get a book, and read up on how a new topic is done in VB.NET then rewrite. More fun too!

 

[KidCoder]

Alrighty, thanks. I think I can mooch a book off of my parents.