Usage of each block

Active workbook

Indicates the active book.
Combine this block when you want to target the active book in a block that manipulates the book (such as save) or a block that represents the book's attributes (such as file name).

Specify a workbook by file name

Specify one of the currently open workbooks by its file name.
Combine this block with a block that manipulates a workbook (such as save) or a block that represents a workbook's attributes (such as file name) when you want to target a specific workbook.

A series of operations on a book

Specify a book and perform a series of operations on it.
In the "Active book" block, insert a block to specify the book.
That book will be the target of the operation.
In this block, insert the block of the operation you want to perform.

Target workbook

This block represents the book that is the target of the operation in the "Series of operations on the book" block.

Save workbook as

Save the workbook as.
In the "Block to be operated" field, enter the block that represents the workbook to be saved.

Save workbook

Save the open book by overwriting it.
In the "Block to be operated" field, enter a block that represents the book to be saved.

Workbook filename

Get the book filename.
In the "Target block" section, insert a block that represents the book you want to get the file name for.

Full path name of workbook

Get the full path name of workbook.
In the "Target block" section, insert a block that represents the book you want to get the full path name for.

Workbook folder name

Gets the name of the folder in which the book is saved.

In the "Target block" field, enter the block representing the book for which you want to get the folder name.

List of workbooks

Gets a list of currently open books.
Combine this with the "Execute for each item in the list" block in the "Repeat" group to process all open workbooks in order.

Count of workbooks

Gets the number of currently open workbooks.

« Previous page：Overview