VBScript to be deprecated

Jeffrey Mahoney

Well-known Member

Joined

May 31, 2015

Messages

2,856

Office Version

1. 365

Platform

1. Windows

• Thursday at 11:55 AM

• #2

Thank you

 

Upvote 0

R

rlv01

Well-known Member

Joined

May 16, 2017

Messages

2,996

Office Version

1. 365
2. 2010

Platform

1. Windows

• Thursday at 12:56 PM

• #3

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.

 

Upvote 0

PeteWright

Active Member

Joined

Dec 20, 2020

Messages

438

Office Version

1. 365

Platform

1. Windows
2. Mobile

• Thursday at 5:30 PM

• #4

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.

Click to expand...

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

 

Upvote 0

jkpieterse

Well-known Member

Joined

Dec 3, 2007

Messages

1,437

• Thursday at 5:41 PM

• #5

PeteWright said:

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

Click to expand...

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

 

Upvote 0

PeteWright

Active Member

Joined

Dec 20, 2020

Messages

438

Office Version

1. 365

Platform

1. Windows
2. Mobile

• Thursday at 5:54 PM

• #6

jkpieterse said:

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

Click to expand...

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?

 

Upvote 0

JEC

Well-known Member

Joined

Aug 21, 2021

Messages

1,609

Office Version

1. 365

Platform

1. Windows

• Friday at 1:38 AM

• #7

Standard regex functions are coming to excel

 

Upvote 0

Jeffrey Mahoney

Well-known Member

Joined

May 31, 2015

Messages

2,856

Office Version

1. 365

Platform

1. Windows

• Friday at 10:18 AM

• #8

@JEC

Standard regex functions are coming to excel

Click to expand...

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?"

 

Upvote 0

JEC

Well-known Member

Joined

Aug 21, 2021

Messages

1,609

Office Version

1. 365

Platform

1. Windows

• Friday at 10:23 AM

• #9

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 - Automate Excel

In this ArticleWhat is Regex?Matching CharactersQuantifiersGroupingHow to Use Regex in VBATesting a Pattern for a Match Against a StringReplacing a Pattern in a StringMatching and Displaying a Pattern in a String This tutorial will demonstrate how to use Regex in VBA. What is Regex? Regex stands...

www.automateexcel.com

 

Upvote 0

Cubist

Well-known Member

Joined

Oct 5, 2023

Messages

1,175

Office Version

1. 365

Platform

1. Windows
2. MacOS

• Friday at 10:46 AM

• #10

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 parse text more easily: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE!

insider.microsoft365.com

 

Upvote 0