The trial version is the full program, so you are not missing anything.

MapPoint doesn't come with a VBA Editor itself, you have to program it from something else like Excel VBA. See examples at

Working With Excel and MapPoint - MP2K Magazine

It can also be automated via other programs like WSH, .NET, Perl and Python, see articles at http://www.mp2kmag.com/articles

Other popular options are Visual Basic 6 and C#, check out the books MapPoint for Dummies and Programming MapPoint .NET respectively.

hope this helps,
Eric