|
Title: cell fill count Post by: skyleet on January 07, 2010, 05:50:26 PM 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. Title: Re: cell fill count Post by: Arthur Grasin on January 08, 2010, 10:38:59 AM 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. |