4 ms·
VBScript must be different from Excel Visual Basic right? Because there’s a lot of people who still use that.
by ls612 3y ago
VBScript must be different from Excel Visual Basic right? Because there’s a lot of people who still use that.
- schlauerfox 3y agoVBScript is in a .vbs file and run from the command line. There are still lots of tools in office and windows that use this like the command line licensing tools olk.vbs and slmgr.vbs so this is an odd security over functionality decision. Excel macros are written in this by fortunate decisions in the article below, not sure if the windows cscript and wscript tools that execute vbs have dependency ties to excel https://www.joelonsoftware.com/2006/06/16/my-first-billg-review/ https://www.joelonsoftware.com/2006/06/16/my-first-billg-rev... like outlook does to the word editor dlls.
- freedomben 3y agoI'd be fascinated to learn what a previous employer will do with all the vbscripts I wrote on Windows XP to drive various things of theirs. They have to maintain things for 20 to 30 years and they are basically snapshots in time. When I was there in the mid 00s they still had a Windows 95 test bench that ran software that only worked there. So I guess there's my answer: they'll keep the Win XP boxes around as long as they need to.
- Aeolun 3y agoIt’s weird to think that be best versions of windows are older than my entire professional career by this point.
- mschuster91 3y ago> So I guess there's my answer: they'll keep the Win XP boxes around as long as they need to. Anything that can be virtualized should be virtualized.
- nxobject 3y agoAnd airgapped from as many things as possible in existence, I hope.
- htag 3y agoYou either have an airgap or you don't.
- mschuster91 3y agoI think they mean firewalls and network segmentation.
- freedomben 3y agoYep, fortunately they are airgapped (though they do have USB ports)
- kevingadd 3y agoAren't excel macros VBA, not VBScript? Different language and a different execution engine.
- Turing_Machine 3y agoYes, they are. Similar in some ways, but different. I doubt if they'll ever be able to remove VBA. Way too much legacy code... the customers would mutiny.
- deafpolygon 3y agoSince Python is being added to Excel... I wouldn't be surprised if they phase that out (excel macros) in favor of it (Python).
- shortrounddev2 3y agoYes, vbscript is the default scripting language for windows. Many viruses have been spread because .vbs files were set to auto-run: https://en.m.wikipedia.org/wiki/ILOVEYOU https://en.m.wikipedia.org/wiki/ILOVEYOU
- actuallyalys 3y agoYeah, this article doesn’t do a great job of disambiguating among VBA (in Excel, Word, etc. and probably sticking around), VBScript in the browser (in Explorer, defunct), and desktop scripting VBScript (now deprecated). The Wikipedia articles for VBA and VBScript seem to suggest that VBA is an embedded implementation of Visual Basic (pre .Net) whereas VBScript is a separate scripting language with similar syntax and features.
- smitty1e 3y agoVBS is basically VBA without any of the typing/early binding, i.e. everything is a Variant. I seem to recall a couple of other pesky nuances. One thing I thought was a win decades ago in the ASP/pre-jQuery days was being able to tell where the code would execute based upon language.vVBSsript on the server; JS in the browser. JS seems like an out-of-body experience as it is.