Sunsetting of Microsoft VBA Macros

[Pestomania]

Hello,

We have been informed that VBA Macros has the potential of being sunset in the next few years. Has anyone looked into alternatives when that does occur? Are there other programming languages recommended?

 

[Joe4]

That rumor has been going around for years, and there is no truth to it.
There are no plans to get rid of VBA Macros in the near future.

 

[Pestomania]

That rumor has been going around for years, and there is no truth to it.
There are no plans to get rid of VBA Macros in the near future.

Good to know.

Now the other side of the question is that our Cyber Security team is considering restricting or removing all macros as a security risk. Do you have alternatives that may be beneficial if that occurs?

 

[Joe4]

Good to know.

Now the other side of the question is that our Cyber Security team is considering restricting or removing all macros as a security risk. Do you have alternatives that may be beneficial if that occurs?

That seems a bit heavy-handed, IMO. There are ways to be secure without doing a full-scale block of all code.
You can use things like:
- Digital signatures (only allow code that has been digitally signed by specific users)
- Set up trusted locations (only allow code from files stored in certain specified locations on your network)

I have never investigated any alternatives, so cannot provide any recommendations there.

 

[Joe4]

Another option may be to create an Add-In from your code. I have never done this myself, but have heard of others doing it.