Named Cells as Parameters

The SaveToDB add-in allows using Excel named cell values as query parameters.

For example, you can create a named cell, like account_id, to get and set the account_id parameter values.

Create such named cells with a worksheet scope.

You can also create named cells with a workbook scope using the global_ prefix like global_account_id.

In this case, when a user changes the cell value or any account_id parameter, the add-in will update all queries that have the account_id parameter.

Be careful if your workbook has a lot of worksheets.

You can also use named cells with __name suffixes to get the displayed value instead of the parameter value.

For example, if the account_id has a value list, the account_id cell will contain an integer value, while account_id__name will contain its name.