Quote Originally Posted by Shaggy Hiker View Post
To get back to the original question, VBA is far more similar to VB6 than VB.NET is. You could think of it as "being a different kind of VB like VBA", but only if you are very loose in your categorizations. The syntax is largely the same, but everything else is different. This makes conversions both possible and seriously error prone. Therefore, most folks here recommend re-writing when moving from VB6 to any of the .NET versions, though I would also add that you can copy and paste individual functions from one to the other, if they are small and can be easily altered to a more .NET style.
I can back this up, the newest version of VBA (Office 2007) is still just a stripped down version of vb6, which if I might add, is a really f-ing annoying language to program in.

One of my two jobs has be programming in vba in Access 2003 & 2007. Very tedious.