Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free.

This question already has an answer here:

I need to get VB Script training so I think it's a good start point.

share|improve this question

marked as duplicate by Glenn Nelson, gnat, thorsten müller, Martijn Pieters, Giorgio Apr 14 '13 at 2:09

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Sharing your research helps everyone. Tell us what you've tried and why it didn’t meet your needs. This demonstrates that you’ve taken the time to try to help yourself, it saves us from reiterating obvious answers, and most of all it helps you get a more specific and relevant answer. Also see How to Ask –  gnat Apr 13 '13 at 19:46

2 Answers 2

VBA is "embedded" usually in MS Office documents. VB Script is run as a script. Please see this link, it can provide more detail http://musannif.blogspot.com/2008/08/difference-between-vb-vba-and-vbs.html

share|improve this answer

VBA is Visual Basic for Applications. It is embedded in the MS Office package and it is used to program the applications (form example to automate some task) from the outside (from the VBA engine).

VB Script is Visual Basic Scripting engine that is usally embedded into some application (Internet Explorer, e.g.) and can be used to automate tasks and perform other actions from inside the application itself.

share|improve this answer
I'm not sure I buy your "inside, outside" distinction. VBA code is usually found inside the application, while VBScript generally does it's work by manipulating application objects from the outside. –  Robert Harvey Nov 30 '12 at 18:02
Also, VBScript is the language used in classic ASP webpages and is more comparable with things like PHP. –  Mr Lister Nov 30 '12 at 18:24
Yes, the line inside/outside is very thin and questionable. Unfortunately, I cannot think to another way to explain the differences in really simple words. –  AlexBottoni Nov 30 '12 at 19:29

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