Other Functions (Apache OpenOffice Runtime Library)

From Apache OpenOffice Wiki
Jump to: navigation, search


Beep

The Beep function causes the system to play a sound that can be used to warn the user of an incorrect action. Beep does not have any parameters:

Beep     ' creates an informative tone

Shell

External programs can be started using the Shell function.

Shell(Pathname, Windowstyle, Param, bSync)
Pathname 
the path of the program to be executed.
In MS-Windows, use ConvertToURL(Pathname) otherwise the command will not work if Pathname contains spaces or national characters.
Windowstyle 
the window in which the program is started.
The following values are possible:
  • 0 - The program receives the focus and is started in a concealed window.
  • 1 - The program receives the focus and is started in a normal-sized window.
  • 2 - The program receives the focus and is started in a minimized window.
  • 3 - The program receives the focus and is started in a maximized window.
  • 4 - The program is started in a normal-sized window, without receiving the focus.
  • 6 - The program is started in a minimized window, the focus remains in the current window.
  • 10 - The program is started in full screen mode.
Param 
command line parameters to be transferred to the program to be started.
bSync 
wait for shell command to finish flag
  • true - wait for shell command to finish
  • false - don't wait for shell command to finish

Wait and WaitUntil

The Wait statement suspends program execution for a specified time. The waiting period is specified in milliseconds. The command:

Wait 2000

specifies a delay of 2 seconds (2000 milliseconds).

The WaitUntil statement provides a greater degree of compatibility with VBA parameter usage. WaitUntil takes a parameter of type Date, with a combined date and time value. The command:

WaitUntil Now + TimeValue("00:00:02")

specifies the same delay, 2 seconds, as the previous example.

Environ

The Environ function returns the environmental variables of the operating system. Depending on the system and configuration, various types of data are saved here. The following call determines the environment variables of temporary directory of the operating system:

Dim TempDir
TempDir=Environ ("TEMP")


Content on this page is licensed under the Public Documentation License (PDL).
Personal tools