Introduction
Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Shell Function

Starts another application and defines the respective window style, if necessary.

Syntax:

Shell (Pathname As String[, Windowstyle As Integer][, Param As String][, bSync])

Parameters:

Pathname

Complete path and program name of the program that you want to start.

Windowstyle

Optional integer expression that specifies the style of the window that the program is executed in. The following values are possible:

Windowstyle Meaning
0 The focus is on the hidden program window.
1 The focus is on the program window in standard size.
2 The focus is on the minimised program window.
3 focus is on the maximised program window.
4 Standard size program window, without focus.
6 Minimised program window, focus remains on the active window.
10 Full-screen display.

Param

Any string expression that specifies the command line that want to pass.

bSync

If this value is set to true, the Shell command and all Office tasks wait until the shell process completes. If the value is set to false, the shell returns directly. The default value is false.

Error codes:

5 Invalid procedure call

53 File not found

73 Not implemented

Example:


Sub ExampleShellForWin
    Shell("c:\windows\calc.exe",2)
End Sub