I refer to the example from here: http://www.vbforums.com/showthread.php?t=393082

The (msflexgrid to excel) was working well. The problem is (excel to msflexgrid).

Problem:
--------
1. My msflexgrid default as 20 row. If the excel contain more than 20 row of data. When i load the data. The number of row of msflexgrid did not increase, it mantains 20 row of data only.

2..Range("A1:F7").Copy set the limit of data load from excel to msflexgrid. How do i load all the data from excel to msflexgrid without range limited?

3.Set xlWB = xlObject.Workbooks.Open("C:\Book1.xls") default the direction of the excel file. Can i manually choosing the file myself like using browse?