Copy and Paste All Rows and Columns From Excel to MSHFlexGrid
Version Compatibility: Visual Basic 6
The following code is used to copy and paste all the rows and columns from Excel to MSHFlexGrid. A little alteration will also help you do vice-versa. In VB, vbCr is a carriage return, which in turn means the start of a new row. vbTab means each cell in Excel.
Instructions: Copy the declarations and code below and paste directly into your VB project.