Skip to main content

VBA - Web Automation - Part 1

VBA - Web Automation - Part 1
Sub YouTube()
    Dim i As Long
    Dim IE As Object
    Dim objElement As Object
    Dim objCollection As Object
    ' Create InternetExplorer Object
    Set IE = CreateObject("InternetExplorer.Application")
    ' You can uncoment Next line To see form results
    IE.Visible = True
    ' Send the form data To URL As POST binary request
    IE.Navigate "https://www.youtube.com/feed/trending"
    ' Statusbar
    Application.StatusBar = "www.excely.com is loading. Please wait..."
    ' Wait while IE loading...
    Do While IE.Busy
        Application.Wait DateAdd("s", 1, Now)
    Loop
    ' Find 2 input tags:
    '   1. Text field
    '   <input type="text" class="textfield" name="s" size="24" value="" />
    '
    '   2. Button
    '   <input type="submit" class="button" value="" />
    
    Application.StatusBar = "Search form submission. Please wait..."
    Set objCollection = IE.Document.getElementsByTagName("a")
    i = 0
    While i < objCollection.Length
        
        ThisWorkbook.Sheets("YouTube").Cells(i + 1, 1) = objCollection(i).href
        i = i + 1
    Wend
    'objElement.Click    ' click button to search
    
    ' Wait while IE re-loading...
    Do While IE.Busy
        Application.Wait DateAdd("s", 1, Now)
    Loop
    ' Show IE
    IE.Visible = True
    ' Clean up
    Set IE = Nothing
    Set objElement = Nothing
    Set objCollection = Nothing
    Application.StatusBar = ""
End Sub

Comments

  1. Sathish Kumar GDecember 25, 2017 at 11:52 PM

    To close an internet explorer instance

    Dim IE As Object
    Set IE = createobject("internet explorer.application")
    Set IE= getobject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E}")
    'DO STUFF
    'CLEAN UP
    IE.QUIT
    SET IE = NOTHING

    ReplyDelete

Post a Comment

Popular posts from this blog

VBA - UI Automation Sample code:

VBA Reference to be added: VBA - UI Automation Project sample code Dim MyElement As UIAutomationClient.IUIAutomationElement Dim MyElement1 As UIAutomationClient.IUIAutomationElement 'Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Public Enum oConditions    eUIA_NamePropertyId    eUIA_AutomationIdPropertyId    eUIA_ClassNamePropertyId    eUIA_LocalizedControlTypePropertyId End Enum Sub Test() Dim AppObj As UIAutomationClient.IUIAutomationElement Dim oInvokePattern As UIAutomationClient.IUIAutomationInvokePattern Dim oAutomation As New CUIAutomation ' the UI Automation API\ Dim oPattern As UIAutomationClient.IUIAutomationLegacyIAccessiblePattern Set AppObj = WalkEnabledElements("BTB Portal 3.0 KA") Set MyElement = AppObj.FindFirst(TreeScope_Children, PropCon...
Post a Comment
Read more

Python - PyQt5 set Background image

import sys from PyQt5.QtCore import QSize from PyQt5.QtGui import QImage, QPalette, QBrush from PyQt5.QtWidgets import * class MainWindow ( QWidget ): def __init__ ( self ): QWidget. __init__ ( self ) self .setGeometry( 100 , 100 , 300 , 200 ) oImage = QImage( "test.jpg" ) sImage = oImage.scaled(QSize( 300 , 200 )) # resize Image to widgets size palette = QPalette() palette.setBrush( 10 , QBrush(sImage)) # 10 = Windowrole self .setPalette(palette) self .show() if __name__ == "__main__" : app = QApplication(sys.argv) oMainwindow = MainWindow() sys.exit(app.exec_())
2 comments
Read more

VBA uiautomationcore.dll to save internet explorer download

Copy file  C:\Windows\System32\UIAutomationCore.dll  file to users Documents i.e  C:\Users\admin\Documents  then add reference  UIAutomationClient  to your macro file. Paste below code in your module: Option Explicit Dim ie As InternetExplorer Dim h As LongPtr Private Declare PtrSafe Function FindWindowEx Lib "user32" Alias "FindWindowExA" ( ByVal hWnd1 As LongPtr , ByVal hWnd2 As LongPtr , ByVal lpsz1 As String , ByVal lpsz2 As String ) As LongPtr Sub Download () Dim o As IUIAutomation Dim e As IUIAutomationElement Set o = New CUIAutomation h = ie . Hwnd h = FindWindowEx ( h , 0 , "Frame Notification Bar" , vbNullString ) If h = 0 Then Exit Sub Set e = o . ElementFromHandle ( ByVal h ) Dim iCnd As IUIAutomationCondition Set iCnd = o . CreatePropertyCondition ( UIA_NamePropertyId , "Save" ) Dim Button As IUIAutomationElement...
Post a Comment
Read more