no, I don’t know, VS.NET does not support VBA.
what can you do if you create a new word or excel file, create a managed office solution by installing VSTO 2010 (Visual Studio Tools for Office), you can create managed documents that are processed inside VS 2010 and the automation language is no longer VBA, but C # or VB.NET.
it is a viable solution for new files, for obsolete files you either convert them if they are small, or save the old VBA code and the old VBA editor, as in the picture.
Note that I want MS to make a tool to convert from the old format to the new !: (