VBA

Hi Donna

Thank you for your question.

Your question has two parts. To control another application you need to create an application object.


Please let me know how you get on.

Sub WordExample()

    'Opens word and creates a new document

    Dim appWord As Object

    Set appWord = CreateObject("Word.Application")

    appWord.Visible = True

    appWord.Documents.Add

End Sub

The second part is regardng accessing data from an access database and that could be done in many different ways. One of the easiest is to record using a database query and would not require you to launch access.

I hope that helps. Regards

Laura GB