Private Sub cmdFillList_Click()
Dim lsSQL As String
Dim lrs As New ADODB.Recordset
lsSQL = "SELECT * FROM tblData order by TP"
lrs.Open lsSQL, cnn, 1, 3
If lrs.EOF Then
MsgBox "Khong co du lieu", vbCritical
Set msgInfo.DataSource = lrs
Else
Call Fill_FlexGrid(MSFlexGrid1, lrs, True)
End If
End Sub
Private Sub cmdToExcel_Click()
Dim xlObject As Excel.Application
Dim xlWB As Excel.Workbook
Set xlObject = New Excel.Application
'Them moi 1 file excel
Set xlWB = xlObject.Workbooks.Add
Clipboard.Clear 'Xoa Clipboard
With MSFlexGrid1
'Chon tat ca du lieu co trong MSFlexGid
.Col = 0 'Tu cot thu nhat
.Row = 0 'Tu dong thu nhat (Dong tieu de)
.ColSel = .Cols - 1 'Chon tat ca cot
.RowSel = .Rows - 1 'Chon tat ca dong
Clipboard.SetText .Clip 'Dua vao Clipboard
.Row = 0
End With
With xlObject.ActiveWorkbook.ActiveSheet
.Range("A1").Select 'Chon cell A1 de chuan bi dan du lieu tu flexgid
.Paste 'Dan tu clipboard
.Range("A1").Select
End With
xlObject.Visible = True
End Sub
Private Sub Form_Load()
Moketnoi
End Sub