Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I just came to know that macros in word/excel/powerpoint can be programmed. That is awesome because I've a word document with 70 tables for styling.

I'm a programmer but I don't know VB or VBA or VB .NET. I'm confused with these three. I'm familiar with .NET programming using C#. Now I want to write new macros. Where should I get started? What are VB , VBA , VB .NET which one should I learn? Please suggest some material.

share|improve this question

closed as not constructive by Nifle, Renan, techie007, 8088, BBlake Sep 17 '12 at 14:21

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

2 Answers

VBA is used most commonly for Microsoft Office applications. You'd probably want to link into that the most. Standard VB of course works in Microsoft Office.

VB.net is meant for web applications and don't apply to macros.

share|improve this answer
add comment

VB.NET is not necessarily only for web applications. Any .NET language can potentially be used to hook into Word or any other Office application.

VBA is a good place to start. If your applications become large and difficult to manage, I would suggest moving the code to the .NET platform, and code in any of the .NET languages. If you learn VBA for the Office application at hand, in your case Word, you will gain targeted knowledge of how to program Word, and this will make the move to .NET much easier.

Also, .NET has great support for hooking into an XML version of a document (WordML). There is much more power available to you if you operate on an XML version of the document.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.