Sounds like when Excel was installed it left out VBA.  To fix this, run the installer and do a custom install and choose to install only VBA. Then run Autoupdate (Excel Help menu > Check for Updates).

Most of the time this works and you will then have VBA. If this doesn't work, you will have to completely remove Office and then reinstall (this time don't leave out VBA in your custom install).

If that still does not work, please reference this solution: