ExcelBanter - VBA equivalent vbscript start outlook & word

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA equivalent vbscript start outlook & word (https://www.excelbanter.com/excel-programming/292959-vba-equivalent-vbscript-start-outlook-word.html)

Max Bialystock

VBA equivalent vbscript start outlook & word

Is there a VBA equivalent of this vbscript?

Set oShell = WScript.CreateObject("WScript.Shell")
oShell.Run "outlook"
oShell.Run "winWord"

--
Regards,
David Lindstrom

Rob van Gelder[_4_]

VBA equivalent vbscript start outlook & word

Sub test()
Dim oShell As Object

Set oShell = CreateObject("WScript.Shell")
oShell.Run "outlook"
oShell.Run "winWord"
End Sub

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Max Bialystock" wrote in message
...
Is there a VBA equivalent of this vbscript?

Set oShell = WScript.CreateObject("WScript.Shell")
oShell.Run "outlook"
oShell.Run "winWord"

--
Regards,
David Lindstrom

Max Bialystock

VBA equivalent vbscript start outlook & word

Fantastic!

Thanks for that - I really appreciate your help.

--
Regards,
David Lindstrom

"Rob van Gelder" wrote in message
...
Sub test()
Dim oShell As Object

Set oShell = CreateObject("WScript.Shell")
oShell.Run "outlook"
oShell.Run "winWord"
End Sub

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Max Bialystock" wrote in message
...
Is there a VBA equivalent of this vbscript?

Set oShell = WScript.CreateObject("WScript.Shell")
oShell.Run "outlook"
oShell.Run "winWord"

--
Regards,
David Lindstrom

All times are GMT +1. The time now is 06:51 AM.