- yuanhua2012-12-06论坛元老16420
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Private Const SW_SHOWNORMAL = 1
Private Declare Function SetWindowLong Lib "user32.dll" _
Alias "SetWindowLongA" ( _
ByVal hwnd As Long, _
ByVal nIndex As Long, _
ByVal dwNewLong As Long) _
As LongPrivate Declare Function GetWindowLong Lib "user32.dll" _
Alias "GetWindowLongA" ( _
ByVal hwnd As Long, _
ByVal nIndex As Long) _
As LongPrivate Declare Function SetWindowPos Lib "user32.dll" ( _
ByVal hwnd As Long, _
ByVal hWndInsertAfter As Long, _
ByVal x As Long, _
ByVal y As Long, _
ByVal cx As Long, _
ByVal cy As Long, _
ByVal wFlags As Long) _
As LongPrivate Declare Function FindWindowEx Lib "user32.dll" _
Alias "FindWindowExA" ( _
ByVal hWnd1 As Long, _
ByVal hWnd2 As Long, _
ByVal lpsz1 As String, _
ByVal lpsz2 As String) _
As LongPrivate Declare Function GetWindowThreadProcessId Lib "user32.dll" ( _
ByVal hwnd As Long, _
ByRef lpdwProcessId As Long) _
As LongPrivate Declare Function SendMessage Lib "user32.dll" _
Alias "SendMessageA" ( _
ByVal hwnd As Long, _
ByVal wMsg As Long, _
ByVal wParam As Long, _
ByVal lParam As Long) _
As LongPrivate Declare Function ExtractIcon Lib "shell32.dll" _
Alias "ExtractIconA" ( _
ByVal hInst As Long, _
ByVal lpszExeFileName As String, _
ByVal nIconIndex As Long) _
As LongPrivate Declare Function GetCurrentProcessId Lib "kernel32.dll" () _
As LongPrivate Declare Function GetDesktopWindow Lib "user32.dll" () _
As LongPrivate Const GWL_STYLE As Long = (-16)
Private Const WS_MAXIMIZEBOX As Long = &H10000
Private Const WS_MINIMIZEBOX As Long = &H20000
Private Const WS_SYSMENU As Long = &H80000Private Const HWND_TOP As Long = 0
Private Const SWP_NOMOVE As Long = &H2
Private Const SWP_NOSIZE As Long = &H1
Private Const SWP_FRAMECHANGED As Long = &H20
Private Const SWP_DRAWFRAME As Long = &H20
Private Const WM_SETICON As Long = &H80Public Declare Function SetCursorPos Lib "user32" (ByVal x As Long, ByVal y As Long) As Long
Public Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, ByVal cButtons As Long, ByVal dwExtraInfo As Long)
Public Const MOUSEEVENTF_MOVE = &H1 ' mouse move
Public Const MOUSEEVENTF_LEFTDOWN = &H2 ' left button down
Public Const MOUSEEVENTF_LEFTUP = &H4 ' left button up
Public Const MOUSEEVENTF_RIGHTDOWN = &H8 ' right button down
Public Const MOUSEEVENTF_RIGHTUP = &H10 ' right button up
Public Const MOUSEEVENTF_MIDDLEDOWN = &H20 ' middle button down
Public Const MOUSEEVENTF_MIDDLEUP = &H40 ' middle button up
Public Const MOUSEEVENTF_ABSOLUTE = &H8000 ' absolute movePublic loops_per_millisecond As Long
Public Sub delay(milliseconds As Long)
Dim delay_time As Double, start, now
start = Timer
delay_time = milliseconds / 1000
Do While now - start = 10 Then
ApphWnd = Application.hwnd
Else
ApphWnd = FindOurWindow("XLMAIN", Application.Caption)
End If
End Function
'‘*****************************
Private Sub HasSystemMenu(ByVal Allow As Boolean)
Dim lStyle As Long: lStyle = GetWindowLong(ApphWnd, GWL_STYLE)
If Allow Then
lStyle = lStyle Or WS_SYSMENU
Else
lStyle = lStyle And Not WS_SYSMENU
End If
Call SetWindowLong(ApphWnd, GWL_STYLE, lStyle)
Call SetWindowPos(ApphWnd, HWND_TOP, 0, 0, 0, 0, _
SWP_NOMOVE Or SWP_NOSIZE Or SWP_DRAWFRAME)
End SubPublic Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) '这个是申明一个sleep函数API,意思是暂时停止运行代码 'kernel32这个是引用的DLL文件 VB中申明API都是统一这个格式的
Function Send_MainPage(HeadNO As Long, SubNO As String) As Boolean '自定义函数
Dim brow As Object
Dim vTag As Object, iRow As Long
Dim mType As String
Set brow = CreateObject("InternetExplorer.Application") '引用了IE对象 brow就是一个IE浏览器了
brow.Visible = True
brow.Silent = True '不弹出窗口
brow.Navigate ("http:/") '打开指定页
On Error Resume Next
Do While brow.Busy
DoEvents
Loop
Sleep 1000ss = FindOurWindow(, " - Windows Internet Explorer")
'yy = FindOurWindow(, "Microsoft Excel - 14.xls")
For b = 1 To 10
AppActivate ss
SendKeys "{tab}", True
delay 3000
SendKeys "{End}", True
delay 3000
SendKeys "{End}", True
' delay 1000
mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0
SendKeys b, True
SendKeys "^{v}", True
SendKeys b, True
mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0
SendKeys b, True
' delay 3000
' mouse_event MOUSEEVENTF_RIGHTDOWN, 0, 0, 0, 0
' delay 1000
' SendKeys "^{P}", True
delay 3000
SendKeys b, True
SendKeys "^{v}", True
delay 3000
AppActivate ss
SendKeys "^{Enter}", True
delay 3000
SendKeys "{End}", True
Next
End Function