You are thinking of VBA which is hosted inside Office applications. You can write VBA to build more complex Office actions or automate some of the more repetitive things. (looking at you Excel)
VB is essentially the same language but is not locked inside Office and can be used to compile executables. Essentially creating your own programs.
I would not recommend using outside programs to hook into or interact with the World of Warcraft client.
Basically what Vrak said