Linking

Hi Shailesh

Thank you for your question.

To launch another application you need to work with an Application Object. Here is an example of how to launch Word and make it visible.

Sub WordExample()

    'Opens word and creates a new document

    Dim appWord As Object

    Set appWord = CreateObject("Word.Application")

    appWord.Visible = True   ' Makes Word visible

End Sub

Record a macro in word or excel that selects the correct data then copy that code into the above code after the visible =True line. At the start every line in the other application you will need to enter appWord. (remember the dot).

It takes a little time to get it working smoothly but that should solve your problem.

Regards,

Laura GB