This article explains how to add reference to the Google Earth 1.0 Type library. By adding reference to this library you will have access to many of the APIs provided by google earth.
Note: This API will only be available if you have Google Earth installed on your computer.
In the VBA editor, from the Tools drop down list click on the Reference button:
Check the Google Earth 1.0 Type Library: