Converting Code from VBA to Visual Basic .NET
Nice article for VBA developer
Presents issues to consider when converting your Microsoft Office solutions from Visual Basic for Applications (VBA) to Visual Basic .NET. Provides a general overview of their differences, and then uses examples from Word and Excel to describe how you can use Visual Studio Tools for the Microsoft Office System to convert your code. (20 printed pages)
Contents
Introduction
Should I Convert my VBA Code to Visual Basic .NET?
Differences Between VBA and Visual Basic .NET
Language Differences
Project Management Differences
Security Differences
Deployment Differences
Converting VBA Code
VBA Code Example in Word
VBA Code Example in Excel
Conclusion
Appendix
Related Articles
For more ...http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/VBAConvert.asp
Suresh Behera