VBScript Being Deprecated

[RMittelman]

So I'm getting emails saying Microsoft is not only depricating VBScript, but eventually removing it entirely, and suggesting JavaScript or Powershell. I use VBScript extensively, either stand-alone or by referencing Microsoft Scripting Runtime, Microsoft VBScript Regular Expressions, and/or Winows Script Host Object Model.



I'm guessing that once VBScript is gone, those references won't work either. If so, how to replace that functionality in my Access projects? I guess I could write a bunch of code in VBA, put it in a project, and reference that project from my other projects in lieu of the above references.

Any suggestions? Thanks...

[Minty]

There is a discussion about this here:
https://www.access-programmers.co.uk.../#post-1921324

Along with other planned changes that may stop things working in the long term

[RMittelman]

There is a discussion about this here:
https://www.access-programmers.co.uk.../#post-1921324

Along with other planned changes that may stop things working in the long term

Thanks Minty. The article wasn't extremely helpful, but it mentioned this article: https://techcommunity.microsoft.com/...s/ba-p/4148301

That contained a comment from Microsoft:

Naveen_Shankar
Microsoft

‎May 23 2024 09:44 AM

@empi_ml, @nolongerset - The scope of VBScript deprecation includes only vbscript.dll and no other libraries. This shall not impact any projects that are not dependent on vbscript.dll.

The VBA team is committed to provide more updates around the alternatives/new developments soon. Stay tuned for further information

This is encouraging. Perhaps references to VBScript.dll can be removed from VBA projects and the actual objects needed could be used instead?

The main challenge I see is if you use regular expressions in your VBA projects. The References entry "Microsoft VBScript Regular Expressions 5.5" points directly to vbscript.dll.

[Micron]

Isn't MS Scripting Runtime library scrrun.dll, so that is not the same? I'm assuming most people who use scripting are using that and not VBScript.dll. I can't even find a reference that points to vbscript.dll

[RMittelman]

You are correct to a point. Scripting Runtime uses scrrun.dll but if you need regular expressions the reference points to vbscript.dll. Try adding that to a project and you'll see the file name.

When that's gone how do we do regex?