in the company we have a mix of: .net desktop and server applications, excel macros and excel VBA applications. There are a lot of excel templates loading data from oracle database (.net vsto plugin), but many calculation are done in many excel templates. So this is a time consuming process for my colleges. For 10 years the number of excel templates was very low, but now the number has increased.
My colleague wants, that I develop a .net server application, but we need pro or contra arguments for doing this (the current process works fine for many years and this is a critical process in the company, also effort,costs and "political things" are to consider).
My colleagues contra argument are, that there are many discussion in the IT about "Security Update can block Excel macro" and "VBA will be not the future".
So I need to know: What is the future of VBA, what about security updates?
I do not found some official statements from microsoft about that.
I make some google research, but I do not found a lot or only old articles https://smurfonspreadsheets.wordpress.com/2017/09/28/is-vba-a-dead-end/
Security Update blocks Excel macros (year 2014):
It would be fine to get more official information. What are the current plans about VBA and must I have the fear, that security updates block excel macros and our processed doesn't work?
Many thanks in advance
.net application developer and interface support