List Project Explorer subfolders and windows
X-Function not designed for Auto GetN Dialog.
1. pe_dir;
2. pe_dir page:=W;
3. pe_dir name:=B*
4. pe_dir name:="B*" recursive:=1 display:=1 sensitive:=1;
5. pe_dir recursive:=1 display:=1 sep:=##;
Please refer to the page for additional option switches when accessing the x-function from script
Input
string
name of the desired page; "*" will match all the pages
W = Workbook, G = Graph
Output
names of the pages found
int
Specify whether to search the subfolders for files. Option lists:
Specify the list display form. Only available when recursive=1. Option lists:
Specify whether the page name display is case sensitive or not. Option lists:
Specify the separators for the description. Only available when display=1 to show the description for the folders and windows.
Note: If use the left bracket (for example: (, [, { and < ) as the separators, it will be converted to right bracket for the right side separators.
This X-Function is used to display pages/subfolders inside the current folder.
To give a list of all subfolders as well as pages, use
pe_dir
To give a list of all pages, use
pe_dir name:=*
To give a list of all graph pages, use
pe_dir page:=g
To give a list of all worksheet pages, use
pe_dir page:=w
To output all page names to a string variable, use
pe_dir oname:=stringName
pe_cd