Help Centre › Building Processes
Get the title or path of the workbook that opened most recently, in any running copy of Excel.
Runs on: Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Get newest open workbook under Excel › Workbook, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Value | No | Path gives the full file path, Title the workbook name Excel shows Choices: Path, Title. Default: path. |
| Variable | Yes | Variable that gets the title or path of the newest workbook |
| Keys | No | Workbooks to leave out, one per row: a full path, a folder and file name, or just the file name. Rows can use variables and formulas, and `*` stands for any run of characters. A variable holding a list leaves out every workbook in it |
What it gives back
{variable}– Title or path of the newest workbook
See all Excel steps.