The support for VBA was discontinued since AutoCAD 2010; however you can download and install VBA extension for all versions up to 2013. This is intended for existing VBA custom tools.
For new tools is better to look for AutoLISP or .Net.
Regarding access to Excel from an AutoCAD based tool the answer is yes, it is possible. You can find a lot of examples on the Forum.