|
本帖最后由 lhj323323 于 2011-6-4 16:50 编辑
Private Sub CommandButton1_Click() '窗体的“运行”按纽
res = MsgBox("请确认是否将文本文件数据导入到数据库中?", vbYesNo, "导入确认")
If res = vbYes Then '2
CommandButton7.Caption = "取 消" '原[退出]按纽变为[取消]按纽
Label1.Caption = "系统正在加载数据文件,请稍后 ...."
Label1.Visible = True
On Error GoTo errbad
'=========进度条=========================
ProgressBar1.Min = 0
ProgressBar1.Max = w
Label14.Caption = "0%"
ProgressBar1.Value = h
Label14.Caption = Round(h / w, 2) * 100 & "%"
DoEvents
h = h + 1
'========运行程序======
。。。。。。。。。。
========程序运行结束======
If Label14.Caption = "100%" Then
Rows("1:1").AutoFilter
Label1.Caption = "文本数据加载成功!"
MsgBox "系统已经成功提取并导入数据!", vbOKOnly, "系统响应"
Else
Label1.Caption = "文本数据加载失败!"
MsgBox "原始文本数据中包含有异常结束符,请替换所有异常字符后重新执行操作!", vbOKOnly, "系统响应"
End If
Label1.Visible = False
CommandButton7.Caption = "退 出"
Unload UserForm1
Exit Sub
errbad:
MsgBox "数据导入失败或终止,若为非人为终止请检查数据文本的准确性!", vbOKOnly + vbCritical, "系统响应"
Unload UserForm1
Else
End If
End Sub
- Sub 进度条()
- Dim W%, h%
- '进度条初始化#####
- W = 100
- ProgressBar1.Min = 0
- ProgressBar1.Max = W
- Label14.Caption = "0%"
- '##############
- '假设以下是你的程序过程 一个循环********
- For h = 1 To W
- ProgressBar1.Value = h
- Label14.Caption = Round(h / W, 2) * 100 & "%"
- Next h
- '***************************
- End Sub
复制代码
|
|