Make VB6 programming part of Office
VBA programming is already part of Office. It's sister language VB6 should become part of the Office family and be updated to the same standard as VBA7.
VB6 should allow compiling to standalone .Exe files, but otherwise it should retain compatibilty with VBA.
There is still a large volume of legacy Visual Basic 6 code that needs supporting.
We want to thank everyone for their comments and votes on this thread. This is not the first time we’ve received this sort of request. We’ve also heard this feedback on the Excel UserVoice forum. You can read our full response at https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8843113-bring-vba-into-the-modern-world.
We’ll summarize the key points here.
VBA will still continue to be supported in Office, and as we add new features in the Windows desktop versions of Office, we will add object model APIs for those features. You can find more details about feature improvements here: https://aka.ms/odevblog-vba.
Again, we appreciate the developer passion around VBA, and we’ll continue supporting VBA.
Office Extensibility Team
Hey, I need both, the excel VBA and the power of Visual Basic 6.0 in compiled versions.
D.L. Owen commented
Its as if Microsoft has no idea how real people use VBA in real life. I have tried in good faith to understand, to learn and to get on board. But it makes no sense. Cloud, cross-device & cross-platform are important for web devs, not for Office devs. We aren't all making commercial consumer apps. I will test anything, provide feedback, whatever I can do to help Office automation improve in a useful way. Lets get this moving and stop pretending the JS API as it is today is even close to being an adequate replacement for VBA/COM.
I support VB6 programming, VBA programming and VBScript programming
VB6 Programming commented
Yes I would vote for this and use it.
Update VB6 to the latest VBA standard,so the VB6 and VBA programming languages are identical.
Ideally also add a few of the more popular dotnet features too, but without losing VB6/VBA backward compatibility.
I use VBA. Programming with VB6 would be useful too.
Microsoft should merge VBA and VB6 programming.
Yes, add VB6 programming to Office together with VBA programming.
VBA Programming commented
Microsoft say VB6 programming is "everyone's favorite".
So why won't they update VB6 to the same standard as VBA programming ?
Very good idea. We just used VBA to update many hundreds of files, a couple thousand really. As long as I can't do that with Google Docs, I'll never stray from Microsoft.
We like VB6 programming commented
Microsoft should do this. Visual Basic is still popular.
I should add that Microsoft can be fine without VBA, but Office does need a modern & sophisticated scripting language, VBA or not.
Microsoft has to realize who are paying for Office, and what keeps Google Office at bay: It's VBA scripting that professional Office users rely on. Without VBA, Microsoft Office is just another Google Office and why would anyone has to stick with Microsoft.
This is a good idea.
VBA programming and VB6 programming are almost identical. It makes sense to have them together.
VB6 programming will be used as long as Windows is.
Now is the time to add the same 64 bit improvements to VB6 that have already been added to the latest version of VBA programming.
I'll vote for this. Microsoft should have done it years ago.
Alan Hughes commented
In fact this is such a sensible idea I can't see Microsoft adopting it. Their loss.
Alan Hughes commented
This suggestion , for once, actually makes good sense.
It should be done.
Andrew Scott commented
Microsoft should do this. VBA and VB6 should be merged.
Support VB6 programming commented
Great idea. VB6 and VBA are almost identical. Obviously they should both be developed and supported by the same team.
VB6 programming and VBA programming are both essential to business.
VB6 is still widely used in business. There is a lot of legacy VB6 code that will be in use as long as Windows lasts.
We need to support it. Make VB6 programming part of Office.
I and my colleagues still use VB6 and VBA programming everyday.