Excel

Create a sheet called parameters. In this sheet set up names down the left hand side, and values in the next column. Then names can be created for the cells on the right hand side. These form the parameters to be used elsewhere.

A typical example would be the name, password and database to use in a database connection.

This sheet should be hidden as part of the debug on / debug off macro