Capture destination dialog box

This dialog box is displayed when you click the Capture to Excel button in Table range dialog box when the HTML tag is a TABLE. It generates the proper CaptureTableHTML function and the proper WriteExcel function within WinTask script in order to capture the data displayed in the selected cells in a Web page and to write them in the specified Excel file.

In "Excel file" field, specify the Excel file where the captured data has to be written, or Browse for it. When you run the script, the Excel file must be closed.

In "Sheet name" field, specify the sheet name if any, the default is to write in Sheet1 of the specified Excel file.

In "Cell starting at" field, specify the cell where the captured data must be copied.

Check "Insert as a row" if the captured data must be written as a row, or check "Insert as a column" if you want them inserted as a column.

Click Paste into the script button for generating the CaptureTableHTML and the WriteExcel lines which will capture the data you have specified at execution.

Click Cancel for cancelling and coming back to the Spy main window.