Copy and Paste All Rows and Columns From Excel to MSHFlexGrid
Category:
Office/VBAType:
SnippetsDifficulty:
IntermediateAuthor:
AnonymousVersion Compatibility: Visual Basic 6
More information:
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.
Declarations: