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

 

[Jeffrey Mahoney]

Thank you

 

[rlv01]

Thanks for the heads up. It's going to break code as the Scripting Dictionary and The FSO are things I use often, but at least I have time to come up with a remediation plan. I suppose this explains why MS never updated the FSO to deal with OneDrive and SharePoint.

 

[PeteWright]

VBScript deprecation: Timelines and next steps

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.

As you can see in the below screenshots, the FileSystemObject should not be affected since it's another DLL,
but the Regular Expressions will be deprecated.

Am I right?
Can someone confirm that?

If the FSO will stay things aren't soo bad, but how about the RegEx, what should I use instead?
Any suggestions?

Best regards
Pete

 

[jkpieterse]

VBScript deprecation: Timelines and next steps


As you can see in the below screenshots, the FileSystemObject should not be affected since it's another DLL,
but the Regular Expressions will be deprecated.

View attachment 111840View attachment 111841

Am I right?
Can someone confirm that?

If the FSO will stay things aren't soo bad, but how about the RegEx, what should I use instead?
Any suggestions?

Best regards
Pete

I think you are, see: VBScript deprecation: Timelines and next steps

 

[PeteWright]

I think you are, see: VBScript deprecation: Timelines and next steps

I'm not quite sure if I got you right.

Just for clarification:

Filesystem Object will stay
Regular Expressions will be removed

For the RegEx, do you know what I can use instead?

 

[JEC]

Standard regex functions are coming to excel

 

[Jeffrey Mahoney]

@JEC

Standard regex functions are coming to excel

I saw that on a video. Can you explain what the use is for those functions. If I can put it in laymen's terms, "wut is all that gobbledigook in the parameters?"

 

[JEC]

Regular expressions are being used to extract complex substrings. Takes time to learn but is is very powerful. I am a fan

See this page for info

VBA Regex

This tutorial will demonstrate how to use Regex in VBA. What is Regex? Regex stands for regular expression. A regular expression is a pattern made up of a

www.automateexcel.com

 

[Cubist]

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