|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Private Sub workbook_open()
- '坛友提供,你参考
- On Error Resume Next
- Application.DisplayAlerts = False
- If Now() >= CDate("9/26/2017 10:22:00") Then
- ActiveWorkbook.ChangeFileAccess xlReadOnly
- Kill ActiveWorkbook.FullName
- Application.Quit
- End If
- Application.DisplayAlerts = Ture
- End Sub
- Sub test()
- Const appName = "ExcelBookA"
- Const section = "UsedInformation"
- Const key1 = "第一次打开时间"
- Const key2 = "上次打开时间"
- Const key3 = "打开总次数"
- Dim i%
- Dim arr As Variant
- Dim strInfo$
- arr = GetAllSettings(appName, section)
- If Not IsArray(arr) Then '如果注册表项存在则返回一个数组,如果第一次运行这段代码,注册表中不存在信息,则写入注册表
- SaveSetting appName, section, key1, Now()
- SaveSetting appName, section, key2, "没有记录"
- SaveSetting appName, section, key3, 0
- End If
- i = GetSetting(appName, section, key3)
- SaveSetting appName, section, key3, i + 1
- arr = GetAllSettings(appName, section)
- strInfo = "以下是当前工作薄的使用情况:" & vbCr
- For i = LBound(arr) To UBound(arr)
- strInfo = strInfo & vbCr & arr(i, 0) & ":" & arr(i, 1)
- Next
- strInfo = strInfo & vbCr & vbCr & "要清除记录信息吗"
- If MsgBox(strInfo, vbDefaultButton1 + vbYesNo) = vbYes Then
- DeleteSetting appName
- Else
- SaveSetting appName, section, key2, Now
- End If
- End Sub
- '完整案例
- Sub xieru()
- Const appName = "ExcelBookA"
- Const section = "UsedInformation"
- Const key1 = "第一次打开时间"
- Const key2 = "上次打开时间"
- Const key3 = "打开总次数"
- Dim i%
- Dim arr As Variant
- Dim strInfo$
- arr = GetAllSettings(appName, section)
- If Not IsArray(arr) Then '如果注册表项存在则返回一个数组,如果第一次运行这段代码,注册表中不存在信息,则写入注册表
- SaveSetting appName, section, key1, Now()
- SaveSetting appName, section, key2, "没有记录"
- SaveSetting appName, section, key3, 0
- End If
- i = GetSetting(appName, section, key3)
- SaveSetting appName, section, key3, i + 1
- arr = GetAllSettings(appName, section)
- If arr(2, 1) > 5 Then
- MsgBox "使用次数到期!"
- Call killme
- Else
- End If
- End Sub
- Sub killme()
- On Error Resume Next
- With ThisWorkbook
- .Saved = True '先保存,否则转只读会有提示
- .ChangeFileAccess xlReadOnly '转为只读
- Kill .FullName
- .Close False
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|