VB获取网络时间

可以禁止修改系统时间即可，代码如下，源码可以发给你，你的邮箱是？窗体form1(需要一个timer控件，interval=1000):

窗体代码Private Sub Form_Load()

Timer1_Timer

RegisterWindow Mehwnd '为窗口设置子类

End SubPrivate Sub Form_Unload(Cancel As Integer)

unRegisterWindow Mehwnd '取消窗口的子类

End SubPrivate Sub Timer1_Timer()

OldTime = Now

End Sub'模块modle1:Option Explicit

Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long

Public Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long

Public Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long

Public Declare Function CallWindowProc Lib "user32" Alias "CallWindowProcA" (ByVal lpPrevWndFunc As Long, ByVal hwnd As Long, ByVal msg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long

Public Declare Function RegisterWindowMessage Lib "user32" Alias "RegisterWindowMessageA" (ByVal lpString As String) As Long

Public OldTime As String

Public ChangeFlag As Boolean

Public Const WM_TIMECHANGE As Long = &H1E '当系统的时间变化时发送此消息给所有顶级窗口

Public oldproc 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

Private Declare Function SetLocalTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) As LongPublic Function RegisterWindow(hwnd As Long) As Long

If hwnd <> 0 Then

oldproc = SetWindowLong(hwnd, -4, AddressOf WinProc)

End If

End Function

Public Function unRegisterWindow(hwnd As Long) As LongIf hwnd <> 0 Then

SetWindowLong hwnd, -4, oldproc

End IfEnd Function

Public Function WinProc(ByVal hwnd As Long, ByVal msg As Long, ByVal lpara As Long, ByVal wpara As Long) As LongDim i, myttIf msg = WM_TIMECHANGE And ChangeFlag = False Then '系统时间被修改了而且不是本程序修改的ChangeFlag = True '本程序要修改系统时间Call SetToOldTime '修改系统时间Exit FunctionEnd If

ChangeFlag = FalseWinProc = CallWindowProc(oldproc, hwnd, msg, lpara, wpara)

End Function

Public Function SetToOldTime() As String '将时间恢复到设置前的状态

Dim tmp As String

tmp = OldTime '从保存的时间中取出修改前的系统时间

Dim lpSystemTime As SYSTEMTIME

lpSystemTimewYear = Year(tmp) '取出年份

lpSystemTimewMonth = Month(tmp) '取出月份

lpSystemTimewDayOfWeek = -1

lpSystemTimewDay = Day(tmp) '取出日

lpSystemTimewHour = Hour(tmp) '取出小时

lpSystemTimewMinute = Minute(tmp) '取出分钟

lpSystemTimewSecond = Second(tmp) '取出秒

lpSystemTimewMilliseconds = 0

'set the new time

SetLocalTime lpSystemTimeEnd Function

这个其实 就是解析XML 或者 JSON 数据，一般在线翻译 网站都会提供一个API 接口，会返回XML 的数据，，你只要会用MicrosoftXMLDOM 对象 解析XML 就可以了

>

Option Explicit

Sub shuaxin()

Dim xml6 As Object

Dim URL As String '这里应该要声明一下

Set xml6 = CreateObject("MicrosoftXML>

下载指定网上文件（选中详细地址）到C盘根目录下。

Sub Selectdownloadfile2C_drive()

'download the select file

Dim h, s, fil As String, c As Range, ti, url, i

Set h = CreateObject("microsoftXML>

翻译公式如下：

=FILTERXML(WEBSERVICE(">

Sub 访问共享文件()

IPName = "192168010"

UserName = "user"

Passwd = "password"

Shell "net use /delete /y", vbHide

Shell "net use \\" & IPName & " " & Passwd & " /user:" & UserName, vbHide

Shell "C:\WINDOWS\explorerexe \\" & IPName & "\", vbMaximizedFocus

End Sub

以上就是关于VB获取网络时间全部的内容，包括:VB获取网络时间、excel vba怎么把网络词典获取"中文例句、VBA 代码修改 关于判断网络连接等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！