The short answer is NO.

Both VBA and Visual LISP use the ActiveX COM API. ActiveX is not going away. It is a foundation that even .NET can use.

However, VBA is a technology that is no longer supported by Microsoft. The separate install for VBA in AutoCAD 2010 should serve as a wake-up call that you should no longer be writing code in VBA and that you need to migrate all VBA code to .NET languages.

This does not mean that you should stop using the ActiveX interface for Visual LISP. There is no reason to stop using any of the functions that load along with (vl-load-com). These functions will work for years to come.