<div>
<div class="content wysiwyg-content">
Hello all<br />
<br />
I have these 3 grids where i would like to extract the data to excel following this process.<br />
<br />
In column 0 you have the door letter.<br />
<br />
In column 1 from each grid have order groups that link to the door, the P Carrier that link to the door and the Carrier that link to the door.<br />
<br />
I would like to extract to excel based on the door letter.<br />
<br />
How can i do that?<br />
<br />
<b>Name of grids:</b><br />
MSHFlexgrid1<br />
MSHFlexgrid2<br />
MSHFlexgrid3<br />
<br />
Grid look like:<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/12_w52/624128/3-Grids.jpg" target="_blank" title="3 grids (41 KB)"><img alt="3 grids" class="file-block lazyload" style="max-width: 793px;" data-src="https://filedb.experts-exchange.com/incoming/2012/12_w52/624128/3-Grids.jpg" /></a><br />
Excel extract result would be like:<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/12_w52/624130/excel-result-1.jpg" target="_blank" title="excel result (55 KB)"><img alt="excel result" class="file-block lazyload" style="max-width: 391px;" data-src="https://filedb.experts-exchange.com/incoming/2012/12_w52/624130/excel-result-1.jpg" /></a><br />
Thanks again for your help
</div>
</div>


excel-result-1.jpg

3-Grids.jpg

Hello all

I have these 3 grids where i would like to extract the data to excel following this process.

In column 0 you have the door letter.

In column 1 from each grid have order groups that link to the door, the P Carrier that link to the door and the Carrier that link to the door.

I would like to extract to excel based on the door letter.

How can i do that?

Name of grids:
MSHFlexgrid1
MSHFlexgrid2
MSHFlexgrid3

Grid look like:


Excel extract result would be like:


Thanks again for your help

VB6 - Extract 3 grids to excel in format

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.