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.
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.