Sorry if this is not a relevant question, but a serious issue for me. I would like some advice from people who have worked with programming for a long time.

1, I have a fair amount of engineering calculation software (lot of plots and matrix operations) in VB6 and have managed to convert two of them to VB.net. I think I am yet to see any significant benefits from this. Was this necessary? What did I gain?

2, And I am hearing from others that VB.net will soon be obsolete and I will be forced to switch over to Python or C# or something (not Java, hopefully). This will be a big task, but if I have to leave VB.net within 5 years, I should not convert the rest of my software to VB.net but take the pains to learn Python or C# and slowly start converting the old VB3 (mostly recompiled in VB6) code. Any advice on what the future should be for engineering calculation programming?