<< Click to Display Table of Contents >> Navigation:  Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel > Macro command GetTitle

Purpose:

Retrieve the name of a worksheet in the workbook. The worksheet can be accessed by the number only.

 

General notation:

GetTitle ( FileIndex, worksheetnumber,  title )

 

FileIndex is the same index used by the Open command. Using the Open command a spreadsheet file is assigned to a FileIndex for later Read commands. The FileIndex is an integer number between 1 and 9. If a value of 0 is assigned to the FileIndex, this corresponds to the currently opened output spreadsheet.

 

Example:

 GetTitle ( 0, 1, S)

 Text( 'Title = ', S)