导出到excel文件.frm

软件用到的技巧：透明窗体

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Object = "{E95A2510-F3D1-416D-823B-4F840FE98091}#3.0#0"; "Command.ocx"
Begin VB.Form Form17 
   Caption         =   "导出数据到 Excel 文件"
   ClientHeight    =   3690
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   7545
   LinkTopic       =   "Form17"
   LockControls    =   -1  'True
   ScaleHeight     =   3690
   ScaleWidth      =   7545
   StartUpPosition =   3  '窗口缺省
   Begin VB.CheckBox Check1 
      Caption         =   "导出时添加标题栏"
      Height          =   225
      Left            =   3015
      TabIndex        =   6
      Top             =   3000
      Value           =   1  'Checked
      Width           =   2685
   End
   Begin CSCommand.Command Command1 
      Height          =   405
      Left            =   6180
      TabIndex        =   5
      Top             =   3150
      Width           =   1155
      _ExtentX        =   2037
      _ExtentY        =   714
      IconAlign       =   0
      Icon            =   "导出到excel文件.frx":0000
      Caption         =   "开始 &B"
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
   End
   Begin MSComctlLib.ProgressBar ProgressBar1 
      Height          =   225
      Left            =   3045
      TabIndex        =   4
      Top             =   3315
      Width           =   3015
      _ExtentX        =   5318
      _ExtentY        =   397
      _Version        =   393216
      Appearance      =   0
   End
   Begin VB.TextBox Text2 
      Appearance      =   0  'Flat
      BorderStyle     =   0  'None
      ForeColor       =   &H00C00000&
      Height          =   600
      Left            =   3120
      Locked          =   -1  'True
      MultiLine       =   -1  'True
      TabIndex        =   3
      Top             =   2235
      Width           =   4020
   End
   Begin VB.TextBox Text1 
      BackColor       =   &H8000000F&
      BorderStyle     =   0  'None
      ForeColor       =   &H00C00000&
      Height          =   1155
      Left            =   3105
      Locked          =   -1  'True
      MultiLine       =   -1  'True
      TabIndex        =   0
      Text            =   "导出到excel文件.frx":001C
      Top             =   555
      Width           =   4065
   End
   Begin VB.Image Image1 
      Height          =   1695
      Left            =   585
      Picture         =   "导出到excel文件.frx":0108
      Top             =   1155
      Width           =   1800
   End
   Begin VB.Label Label2 
      Alignment       =   2  'Center
      BackStyle       =   0  'Transparent
      BorderStyle     =   1  'Fixed Single
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   300
      Left            =   315
      TabIndex        =   7
      Top             =   585
      Width           =   2595
   End
   Begin VB.Shape Shape1 
      BorderColor     =   &H00C00000&
      Height          =   255
      Left            =   3015
      Shape           =   4  'Rounded Rectangle
      Top             =   3300
      Width           =   3060
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "Label3"
      ForeColor       =   &H00C00000&
      Height          =   180
      Left            =   3135
      TabIndex        =   2
      Top             =   1935
      Width           =   540
   End
   Begin VB.Line Line1 
      BorderColor     =   &H00800000&
      X1              =   3060
      X2              =   7305
      Y1              =   1770
      Y2              =   1770
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "关于导出："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   210
      Left            =   3105
      TabIndex        =   1
      Top             =   285
      Width           =   1050
   End
End
Attribute VB_Name = "Form17"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Command1_Click()
    If Label1.Caption = "拜访记录" Then
        Form17.ProgressBar1.Min = 0
        Form17.ProgressBar1.Max = AllBaiFang.MSFlexGrid1.Rows
    End If
    Dim fn As Integer
    fn = FreeFile
    Dim filename As String
    filename = Me.Text2.Text
    Open filename For Output As #fn
        Dim a As String
    a = "标志ID" _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(0, 1) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(0, 2) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(0, 3) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(0, 4) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(0, 5) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(0, 6)

    If Check1.Value = 1 Then
        Print #fn, a
    End If
    Dim i As Integer
    For i = 1 To AllBaiFang.MSFlexGrid1.Rows - 1
    Print #fn, AllBaiFang.MSFlexGrid1.TextMatrix(i, 0) & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(i, 1) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(i, 2) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(i, 3) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(i, 4) _
            & Chr(9) & AllBaiFang.MSFlexGrid1.TextMatrix(i, 5) _
            & Chr(9) & "'" & AllBaiFang.MSFlexGrid1.TextMatrix(i, 6) & "'"
    Next i
    Close #fn
    Unload Me
End Sub

Private Sub Form_Load()
    Me.Height = 4605
    Me.Width = 7665
    form17show = True
    Me.Icon = MDIForm1.Icon
    Me.BackColor = FormBackColor
    Me.Text1.BackColor = Me.BackColor
    Me.Text2.BackColor = Me.BackColor
    Me.Check1.BackColor = Me.BackColor
End Sub

Private Sub Form_Resize()
On Error GoTo ddd:
    Me.Height = 4605
    Me.Width = 7665
ddd:
End Sub

Private Sub Form_Unload(Cancel As Integer)
    form17show = False
    MDIForm1.Enabled = True
End Sub