Hi Steve,

Here is the complete text from the Help file regarding using Command Line switches for the scheduled task and the results for the automated Excel files created. Note that the separation by salesperson would be accomplished by the UserID and the XDP parameter, rather than a user-specified salesperson folder location assigned in the Filter.

XDView Parameters

XDView parameters respect the Allow export option on the Edit Definition window. For workspaces containing multiple views, only those views with the Allow export option enabled will be sent to Excel.

/XDV:<workspace> or /xdv:<workspace> - Sets the location from which to both load the view and to save the resultant Excel workbook. Enter the full path to the workspace. The Excel workbook receives the GridView workspace name and the individual Excel sheets inherit the GridView views' names.

/XDW:<workspace> - Launches GridView and sends the named workspace (or View) to Excel without operator intervention. Enter the full data path to the workspace or View. The Excel workbook is placed in the subfolder x:\data\XDViews (where 'x:\data' is the path to your data) with the same name as the workspace (or View). The View is refreshed prior to the ExcelDirect function being performed. A log of the automated export is created in the file x:\data\XDViews\GVLog.log.

/XDF:<sheetname:filtername> - Selects the named filter "filtername" for sheet "sheetname" in a workspace. The filtername is separated from the sheetname by a colon. Only enough characters of the filtername to uniquely identify it need to be specified. You may use multiple filternames on the command line. If the filter cannot be found for that sheet, an error is reported in the log and the View or Workspace will not be sent to Excel. (Must be used with /XDW or /XDP).

NOTE: When spaces exist in a "sheetname" and/or "filtername", make sure that quotation marks surround the entire "sheetname:filtername" on the Command Line.

/XDP:<workspace> - Launches GridView and sends the named workspace (or View) to Excel without operator intervention. Enter the full data path to the workspace or View. The Excel workbook is placed in the subfolder x:\data\XDViews\UserID with the same name as the workspace or View (where 'x:\data' is the path to your data and 'UserID' is the ID of the user logged in to GridView).

/XDD - Creates a subfolder with today's date to hold the Excel workbook under x:\data\XDViews or x:\data\XDViews\UserID if XDP is specified (where 'x:\data' is the path to your data and 'UserID' is the ID of the user logged in to GridView). Folder names take the form yyyy-mm-dd and can be used to separate the ExcelDirect runs from different dates. (Must be used with /XDW or /XDP.)