Fri 21 Sep 2007, 16:22Delegate Jigna said...
Jigna has attended:
Excel VBA Intro Intermediate course
Call other applications using VBA
How to call other microsoft applications in Excel using VBA ?
Mon 8 Oct 2007, 10:05Trainer Carlos said...
RE: Call other applications using VBA
Hi Jigna
To call a Microsoft application like Word you use the AppActivate command as in the code below:
NB. You may need to change the path to the address on your computer where Word is stored
Sub CallWord()
Dim MyAppID As Variant
MyAppID = Shell("C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE", 1) ' Run Microsoft Word
AppActivate MyAppID ' Activate Microsoft Word.
End Sub
Hope this helps
Regards
Carlos
