vba 恢复系统本地时间

在VBA中，你可以使用以下代码来恢复系统本地时间：

Option Explicit

Private Declare Function SetLocalTime Lib "kernel32" (ByRef lpSystemTime As SYSTEMTIME) As Long

Private Type SYSTEMTIME
    wYear As Integer
    wMonth As Integer
    wDayOfWeek As Integer
    wDay As Integer
    wHour As Integer
    wMinute As Integer
    wSecond As Integer
    wMilliseconds As Integer
End Type

Sub RestoreLocalTime()
    Dim sysTime As SYSTEMTIME
    
    ' 设置要恢复的日期和时间
    sysTime.wYear = 2022    ' 年份
    sysTime.wMonth = 1      ' 月份
    sysTime.wDay = 1        ' 日期
    sysTime.wHour = 0       ' 小时
    sysTime.wMinute = 0     ' 分钟
    sysTime.wSecond = 0     ' 秒钟
    
    ' 调用SetLocalTime函数恢复系统本地时间
    SetLocalTime sysTime
End Sub

请注意，恢复系统本地时间需要管理员权限。因此，你需要以管理员身份运行VBA代码才能成功恢复系统本地时间