cell fill count

[skyleet]

HI

what if the cell fill count(in the direct excel connection module) is not always the same. All date need to be removed before a new array of data are can be displayed.

so if i send a new array whit data the worksheet need to be filled from the start position and not from the position where it is ended.. i

is this possible whiteout restarting the hole program?

Thank you in advance.

[Arthur Grasin]

You may do following:

1. Direct Excel Connection: deactivate the "Workbook - Save last position" option;
2. You should deactivate the "Direct Excel Connection" plugin before receiving your data array on the "Data export" tab and click the OK button;
3. Open the "Data export" tab and activate the "Direct Excel Connection"  plugin again.
4. Click the OK button;
5. Receive your data.

Alternative:

You may use the DDE server or our ActiveX control and write your own VBA code to fill data.