HP ALM Workflow VBScript
This category will provide articles regarding usage of Visual Basic Script in the workflow module of HP ALM.
If you need to get the parent directory of a given path to a file or a directory, the following function might help.
Not the best performance I have to admit since it is relying on String operations.
' @Author - Alexander Bolte ' @ChangeDate - 2015-02-10 ' @Description - Returns the path to a parent directory for a handed path. ' @Param path - a String providing a path to a directory or a file. ' @Returns a String providing a path to a parent directory including the ' last path delimiter. If an error occurs, an empty String is returned. Function getParentDirectoryPath(path) ' As String Dim dirPath ' As String Dim splitted ' As String Dim i ' As Integer On Error Resume Next dirPath = "" splitted = split(path, "\") For i = lBound(splitted) To uBound(splitted) - 1 dirPath = dirPath & splitted(i) & "\" Next If Err.Number <> 0 Then dirPath = "" Err.Clear End If getParentDirectoryPath = dirPath End Function
- Hits: 2612
Below method gets any row from a provided Microsoft Excel worksheet as a String array. This can be quite handy, if you for example want to get all field names from a worksheet.
The code references a Microsoft Excel API. It automates Excel in a background process and therefore requires Excel to be running as well as the parent workbook of a handed worksheet to be opened before calling this function.
- Hits: 2600
In order to reference a defect / bug currently selected by a user in the Defect GridView the following method can be used.
- Hits: 2609
Page 5 of 6