What is the difference between between vba2003 and visual studio tools for office

plz let me know

VBA allows you to write macros and unmanged code within a given application, such as Excel or Visio. You write the code using a basic IDE.

Visual Studio Tools for Office allows you to create managed code solutions using VB or C# for Word, Excel, InfoPath and Outlook. You write the code within Visual Studio, thus giving you all the benefits and advantages of this professional developer environment.

I hope this helps!

Mike Hernandez
Community Program Manager
VSTO Team

vsto and vba2003 both use excel2003 object model

does this mean that vsto and vba2003 have same Objects

let me know sir

Hi,

Yes, the object model is the same + VSTO adds more functionality (e.g. event handlers for NamedRange).

VSTO has so much more to offer that just plain VBA. VBA is very useful tool but it is just hard to build serious solutions in VBA. Here are some advantages of VSTO over VBA as I see it:
+ Web Services
+ Win Forms
+ Databinding
+ ActionsPane
+ entire .NET framework to you service
+ VS 2005 projects are way more maintainable then code embedded into a workbook/document in VBA's case
+ Security