Visual Basic for Applications (VBA) was what is used in Office Products and that is modeled after Visual Basic 6, not VBScript. VBScript was used mostly for Classic ASP development (both front end and backend).
You could use vbscript for, well, scripting. Essentially taking the same position / purpose as batch files on windows. Pretty sure that still works. I wouldn't do it anymore, personally, but I'm almost positive it's still functional.
You could, but I believe most of VBScript use came from web dev. I have the fortune of working on a classic asp site at work now.