Distribution Manager

The Distribution Manager profile type is used to refresh selected workbooks with specified replacement values and/or to schedule the distribution of selected Distribution Manager workbooks.

Create and Maintain a Distribution Manager Job

1. Use the following table to enter data in the Distribution Manager > Job tab:

   Field	Description
   Job Name	Specify the name of the job.
   Comments	If desired, specify comments related to the job.
   Select the workbooks to process	This section indicates the workbooks and/or folder of workbooks to be included in the run. To: Add workbooks to the job: specify the default values, click the Add Workbook(s) button, navigate, to, and select the desired workbook(s), then click the Open button. Add a folder of workbooks to the job: specify the default values, click the Add Folder button, navigate, to, and select the desired folder, then click the Open button. Remove a workbook or folder: select the item, and click the Remove button. Control the order of worksheets or folders in the list: select the item in the window, then click the appropriate arrow button to move the item up or down in the list.
   Run	If selected, the workbook(s) or folder(s) of workbooks in the folder is processed when the job is run.
   Workbook Name	Displays the name of the workbook or folder assigned to the job.
   Rows	Specify the rows to distribute instead of the entire worksheet.
   Start Macro	If desired, specify the name of the macro to be run prior to refreshing and/or distributing the workbook(s).
   Refresh	If selected, the workbook(s) or folder(s) of workbooks in the folder is refreshed, using the replacement data in the Range Name Replacement tab during the run process.
   Distribution	If selected, the workbook(s) or folder(s) of workbooks in the folder is distributed during the run process.
   End Macro	If desired, specify the name of the macro to be run after refreshing and/or distributing the workbook(s).
   Run Default	Specify the default Run value to be assigned when a workbook and/or folder is added to the job.
   Refresh Default	Specify the default Refresh value to be assigned when a workbook and/or folder is added to the job.
   Distribution Default	Specify the default Distribution value to be assigned when a workbook and/or folder is added to the job.
   Start Macro Default	Specify the default Start Macro value to be assigned when a workbook and/or folder is added to the job.
   End Macro Default	Specify the default End Macro value to be assigned when a workbook and/or folder is added to the job.
   Halt on Error	If selected, and an error is encountered while running the profile, the system stops processing the job.

   Button	Function
   Run	Saves and closes the job, then processes all workbook(s) or folder(s) of workbooks in the folders which are selected to run.

   

2. Use the following table to enter data in the Distribution Manager > Range Name Replacement tab:

   Field	Description
   Range Name Replacement:	This section indicates the ranges of the selected workbooks to be replaced with designated values. To: Display a list of range names in the workbooks assigned to the job: click the Refresh button. Modify values: select the line and make the appropriate change(s). Remove a range in the list: select the item, then click the Remove button. Clear all ranges in the list: click the Clear button.
   Range Name	Specify the name of the range to be replaced.
   Replacement Value	Specify the value to be placed in the associated range.

   Button	Function
   Run	Saves and closes the job, then processes all workbook(s) or folder(s) of workbooks in the folders which are selected to run.

   

3. Proceed to the next step: Schedule Job.