VBScript to be deprecated

[jkpieterse]

To my fellow VBA developers. If you have projects that depend on the Scripting Runtime library, beware. VBScript is going to be turned off and subsequently deprecated on Windows clients. Things like the Dictionary object, the FileSystemObject and other useful libraries will no longer be available and cause compile errors in your code. It isn't happening soon, but at least you'll have time to plan ahead: VBScript deprecation: Timelines and next steps

 

[Scott Huish]

Ah Microsoft getting rid of useful things again. Sigh...

 

[rlv01]

RegEx is also coming to the formula functions.

New Regular expression (Regex) functions in Excel

Check out three new functions that use Regular Expressions to help you parse text more easily.

insider.microsoft365.com

But will the new RegEx functions be callable from VBA?

 

[JEC]

Sure!

 

[MARK858]

But will the new RegEx functions be callable from VBA?

Got the functions in my Beta version but they are not listed in the list of WorksheetFunctions in VBA

Book1
	A	B
1	Data
2	alfalfa
3	Formulas	Questions
4	TRUE	Does it contain the letter 'a'?
5	TRUE	Does it contain any lower case letters?
6	FALSE	Does it contain any upper case letters?
7	TRUE	Does it contain any vowels?
8	FALSE	Does it contain any number digits?
Sheet1

Cell Formulas
Range	Formula
A4	A4	=REGEXTEST(A2,"a")
A5	A5	=REGEXTEST(A2,"[a-z]")
A6	A6	=REGEXTEST(A2,"[A-Z]")
A7	A7	=REGEXTEST(A2,"[aeiou]")
A8	A8	=REGEXTEST(A2,"[0-9]")

 

[MARK858]

Works with Evaluate though

 

[Scott Huish]

I hope they come up with an alternative for Scripting Dictionary.

 

[Alex Blakenburg]

I hope they come up with an alternative for Scripting Dictionary.

It's not currently being deprecated it is in a different DLL to the one being dropped.

 

[Alex Blakenburg]

The details are in the comments of the article being linked to in several of the above posts.
From: nolongerset

• vbscript.dll:
  
  • Microsoft VBScript Regular Expressions 1.0
  • Microsoft VBScript Regular Expressions 5.5
• scrrun.dll:
  
  • Microsoft Scripting Runtime

Reply from the author: Naveen Shankar

"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."​

​

Additional Ref:
> The "Microsoft Scripting Runtime" reference (scrrun.dll) is not going anywhere. That means the FileSystemObject and Dictionary object are both safe for now.

Microsoft Announces End of RegEx Support for VBA

We finally have an official timeline for when Microsoft will be dropping support for VBScript--and what impact that will have on VBA developers.

nolongerset.com