No matter which Microsoft BASIC you use to start OLE automation (Access Basic, VBA for Microsoft Excel, or Visual Basic), you start it with one of two functions:
Once you start OLE automation, you can think of it as a superset of all programming languages that support OLE automation as servers, such as Microsoft Excel and Word. For example, when you build an integrated business application in Access that uses Microsoft Excel as an OLE automation server, you use Microsoft Excel's objects, properties, and methods in your Access Basic code.
Since the Microsoft BASICs are so similar, you can often write code for the OLE automation server in the client just as you would if you were writing it in the server. If you're not comfortable with the server's macro language, start with code from the macro recorder, and then copy into the client. The following section describes how to port code between server and client.