Yes, automation/interrop should give you access to the whole Excel Object;
but you might find
vb.net 'harder' without the benefit of the Excel macro
recorder that does give you a good starting point for VBA.
Why not be bold and use VSTO (Visual Studio Tools for Office)?
"Wired Hosting News" wrote:
I been programming in VBA excel for some time now and although I have not
perfected it, I gotten good enough to exploit much of it.
I have VB.net and am thinking of concentrating on learning that since it
seems so much more powerful them VBA.
My programming does revolve around excel and other office apps.
Should I stick with VBA or move on?
Can I do everything in NET that I can do in VBA and more?
Would I have full access to the excel app and its objects?
Outlook app?