Copy and Paste All Rows and Columns From Excel to MSHFlexGrid

Category:
Office/VBA
Type:
Snippets
Difficulty:
Intermediate
Author:
Anonymous

Version 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:

Code: