open any MS application using macro

[sampath]

Hello,

Need to open any MS application / PDF using macro coding.

Please share the coding.

Regards,
Sampath.S

 

[Deepak]

Pls be specific about the query!!

http://what-when-how.com/excel-vba/interacting-with-other-office-applications-via-excel-vba/

 

[sampath]

Hello Deepak,

Need macro coding for open MS Word (open application and not for particular word file)and close it after 15 seconds.

Please provide the coding.

Regards,
Sampath.S

 

[Deepak]

Check that link...

 

[sampath]

Hello Deepak,

What link to checking.....Pls.

Regards,
Sampath.S

 

[Deepak]

http://what-when-how.com/excel-vba/interacting-with-other-office-applications-via-excel-vba/

or Try this...

Sub test()
Dim t As Double
t = Timer
    With CreateObject("Word.Application")
        With CreateObject("Word.Document")
            .Windows(1).Visible = 1
            .Content = "Mytest"
        End With
    Do While Timer - t < 15: DoEvents: Loop
    .Quit
End With

End Sub