Activating a Microsoft Office application

If the application that you want to start is one of several Microsoft applications, use the Application object's ActivateMicrosoftApp method. For example, the following procedure starts Word:

Sub StartWord()

Application.ActivateMicrosoftApp xlMicrosoftWord End Sub

If Word is already running when the preceding procedure is executed, it is activated. Other constants are available for this method:

i xlMicrosoftPowerPoint (PowerPoint) i xlMicrosoftMail (Outlook) i xlMicrosoftAccess (Access) i xlMicrosoftFoxPro (FoxPro) i xlMicrosoftProject (Project) i xlMicrosoftSchedulePlus (SchedulePlus)

0 0

Post a comment